Managing My Email Table

[tomyknoker]

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

/* 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';

?>

[Titan85]

I don't really get what you are trying to do. Anything else you could tell me?