I have a page that lists all the entries from a table with a radio button next to each one. Once you select the radio button and press the submit button it's supposed to come up with all relevant information to that entrie(field names and such) so you can change (update) anything. But, everytime you push the edit(submit) button it does nothing.......
<form action="<?php echo $PHP_SELF; ?>" method="post">
<?php
mysql_pconnect('localhost','username','password');
mysql_select_db('database');
if(!$cmd)
{
$result = mysql_query("select * from roster");
while($r = mysql_fetch_array($result))
{
$ID=$r["ID"];
$Alias=$r["Alias"];
$Name=$r["Name"];
$Age=$r["Age"];
$Hometown=$r["Hometown"];
$Email=$r["Email"];
$FavSide=$r["FavSide"];
$FavWeap=$r["FavWeapon"];
$FavQuote=$r["FavQuote"];
?>
<INPUT TYPE="RADIO" NAME="ID" VALUE="<?php echo $ID;?>"><?php echo $ID;?> <?php echo $Alias; ?><br>
<?php } ?>
<input type="submit" name="cmd" value="edit"></form>
<?php } ?>
<?php
if($cmd=="edit")
{
if (!$submit)
{
$sql = "SELECT * FROM roster WHERE ID=$ID";
$result = mysql_query($sql);
$myrow = mysql_fetch_array($result);
?>
<input type=hidden name="ID" value="<?php echo $myrow["ID"]; ?>">
Alias:<INPUT TYPE="TEXT" NAME="Alias" VALUE="<?php echo $myrow["Alias"]; ?>" SIZE=30><br>
Name:<INPUT TYPE="TEXT" NAME="Name" VALUE="<? echo $myrow["Name"]; ?>" SIZE=30><br>
Age:<INPUT TYPE="TEXT" NAME="Age" VALUE="<?php echo $myrow["Age"]; ?>" SIZE=30><br>
Hometown:<INPUT TYPE="TEXT" NAME="Hometown" VALUE="<?php echo $myrow["Hometown"]; ?>" SIZE=30><br>
Email:<INPUT TYPE="TEXT" NAME="Email" VALUE="<?php echo $myrow["Email"]; ?>" SIZE=30><br>
FavSide:<INPUT TYPE="TEXT" NAME="FavSide" VALUE="<?php echo $myrow["FavSide"]; ?>" SIZE=30><br>
FavWeap:<INPUT TYPE="TEXT" NAME="FavWeap" VALUE="<?php echo $myrow["FavWeap"]; ?>" SIZE=30><br>
FavQuote:<TEXTAREA NAME="FavQuote" ROWS=10 COLS=30><?php echo $myrow["FavQuote"]; ?></TEXTARE><br>
<input type="hidden" name="cmd" value="edit">
<input type="Submit" name="submit" value="Enter information">
</form>
<?php }
if($submit)
{
$sql = "UPDATE roster SET ID='$ID',Alias='$Alias',Name='$Name',Age='$Age',Ho metown='$Hometown',Email='$Email',FavSide='$FavSide',FavWeap='$FavWeap',FavQuote='$FavQuote' WHERE ID=$ID";
$result = mysql_query($sql);
echo "Thank you! Information updated.";
}
}
?>
