Can anyone tell me why this wouldn't update the database ?
The form echos the info and everything, but the database just will not update.
<?PHP
session_start();
require_once("common/fig.php");
if($submit == "Save personal info. changes"){
$query2 = "update users set first_name='$first_name', last_name='$last_name', email_address='$email_address', country='$country', website='$website' WHERE userid='$userid'";
mysql_query($query2) or die( "ERROR: " . mysql_error() . "\n");
$res="Successfully updated your personal info record";
}
$query="SELECT * from users where userid='$userid'";
$result = mysql_query($query) or die( "ERROR: " . mysql_error() . "\n");
if ($myrow = mysql_fetch_array($result)) {
$first_name=$myrow["first_name"];
$last_name=$myrow["last_name"];
$email_address=$myrow["email_address"];
$website=$myrow["website"];
$country=$myrow["country"];
$username=$myrow["username"];
$password=$myrow["password"];
}
?>
<form action="mydetails.php" method="POST">
<table>
<tr><td></td><td><input type="hidden" name="userid" value="<?echo $userid;?>"></td></tr>
<tr><td>First Name</td><td><input type="text" name="first_name" value="<?echo $first_name;?>"></td></tr>
<tr><td>Last Name</td><td><input type="text" name="last_name" value="<?echo $last_name;?>"></td></tr>
<tr><td>Email</td><td><input type="text" name="email_address" value="<?echo $email_address;?>"></td></tr>
<tr><td>Country</td><td><input type="text" name="country" value="<?echo $country;?>"></td></tr>
<tr><td>Website</td><td><input type="text" name="website" value="<?echo $website;?>"></td></tr>
<tr><td colspan=2><input type="submit" name="submit" value="Save personal info. changes"></td></tr>
</table>
</form>
