I have been playing with this but for some reason it will not work. I think it may have something to do with the "action" parameter. correct? If so, how do you get the page to reload with the the updated data?
I have moved the php code in front of both the </table> and </form> tags as well and still nothing.
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta http-equiv="content-type" content="text/html;charset=iso-8859-1">
<title>Test Update Page</title>
<?php
mysql_connect("localhost", "<id>", "<pw>") or die("Failure to communicate with database");
mysql_select_db("<db>");
$query = "SELECT name, city, st from <db> where name='Bob'";
$result = mysql_query($query);
$parr=mysql_fetch_array($result);
?>
</head>
<body bgcolor="#ffffff">
<form name="form" method="POST" action="<?php echo $SERVER['PHP_SELF']; ?>">
<table width="616" border="1" cellspacing="2" cellpadding="0">
<tr>
<td width="120"></td>
<td width="120"></td>
<td width="120"><?php echo $parr['name'] ?> </td>
<td width="120"></td>
<td width="120"></td>
</tr>
<tr>
<td width="120"></td>
<td width="120"><input type="submit" name="Submit"></td>
<td width="120"></td>
<td width="120"><input type="reset" name="Reset"></td>
<td width="120"></td>
</tr>
</table>
</form>
<?php
if($POST['Submit']) {
echo "It Worked";
} elseif($_POST['reset']) {
echo "you have chosen to reset the form";
}
?>
</body>
</html>
<?php if (false) { ?><!-- Mock Content
"Updt/screenname" html {Label}
"Updt/st" text {}
--><?php } ?>