Results 1 to 2 of 2

Thread: Managing My Email Table

  1. #1
    Join Date
    Apr 2006
    Posts
    584
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Default Managing My Email Table

    I have a table in my database called tblemail, basically it's 4 different types of emails that can be sent to my members. I am trying to create a page to display them but aren't having much luck... This is what I have come up with so far, it's more of the idea so hopefully someone understands what I am trying to do?

    PHP Code:
    <?php

    /* connect to the mysql database and use different queries for the count of members */

    include 'configure.php';
    include 
    'open.php';

    //navigation
    include("nav.php");

    $info mysql_query("SELECT * FROM tblEmail");

    echo 
    '<table border="1" cellpadding="3" cellspacing="1">
    <tr valign="top">
        <td>Email</td>
    </tr>
    <tr valign="top">
        <td>Details</td>
    </tr>
    <tr valign="top">
        <td>Is Active</td>
    </tr>
    <tr valign="top">
        <td></td>
    </tr>'
    ;

    (
    $qry mysql_fetch_array($info))

    //create the layout
    ?>
    <link href="cs_style.css" rel="stylesheet" type="text/css" />

    <tr valign="top">
    <td>
    <?php echo $qry['email_NM']; ?>
        <select name="select">
          <option>Please Select</option>
          <option value="A">Approved</option>
          <option value="R">Rejected</option>
          <option value="H">On Hold</option>
          <option value="P">Pending</option>
        </select>
    </td>
    </tr>

    <tr valign="top">
    <td>
        <?php echo $qry['email_body_TXT']; ?>
        <textarea name="textarea"></textarea>
    </td>
    </tr>

    <tr valign="top">
    <td>
        <?php echo $qry['active_FG']; ?>
        <select name="select">
          <option selected="selected">Please Select</option>
          <option value="1">Yes - Send Email</option>
          <option value="0">No - Don't Send Email</option>
        </select>
    </td>
    </tr>
    <tr valign="top">
    <td>
        <?php echo $qry['active_FG']; ?>
        <input type="submit" name="Submit" value="Update" />
    </td>
    </tr>
    <?php
       
    }
    }

    echo 
    '</table>';

    include 
    'library/closedb.php';

    ?>

  2. #2
    Join Date
    Aug 2006
    Location
    Ohio
    Posts
    266
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Default

    I don't really get what you are trying to do. Anything else you could tell me?
    Thanks DD, you saved me countless times

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •