I have an included form in my email.php file that has the following code in it:
<html>
<head>
<title>Untitled Document</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>
<body>
<form name="form1" method="post" action="">
<table width="85%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td><div align="center">Banned Members List:</div></td>
</tr>
<tr>
<td><div align="center">
<input name="membanned" type="text" id="membanned" value="<? echo $row_Recordset6['banned']; ?>">
</div></td>
</tr>
<tr>
<td><div align="center">
<input name="updatebanned" type="submit" id="updatebanned" value="Update Banned List">
</div></td>
</tr>
</table>
</form>
</body>
</html>
<?php
mysql_free_result($Recordset6);
?>
Then in my email.php file it has this code that should update what the user types into the membanned field:
if (isset($HTTP_POST_VARS['updatebanned'])){
$upbanned = sprintf("UPDATE users SET banned='$membanned' WHERE username='" . $HTTP_SESSION_VARS['username'] . "'");
mysql_select_db($database_themeetmarket, $themeetmarket);
$Result8 = mysql_query($upbanned, $themeetmarket) or die(mysql_error());
$msg="You have successfully updated your banned list";
}
WHAT IS WRONG HERE? NO MATTER WHAT I DO I CAN'T CHANGE THE ORIGINAL DATA THAT IS BEING ECHOED OUT IN THE INLCUDED FILE SHOWN FIRST ABOVE.