...

View Full Version : Managing My Email Table



tomyknoker
03-29-2007, 06:21 PM
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';

?>

iLLin
03-29-2007, 06:42 PM
Read up on while (http://us2.php.net/while).



EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum