Updating more than one field at a time.

[batman]

Hello,

What I am in need of is to make it to where after people sign-up, they can view there information, and also edit / update it whenever they want.

This is the bit of code I am using for the update section.

<?

include 'db.php';

session_start(); 

 if(!session_is_registered('first_name')){ 

include 'login_form.html'; 

exit(); 

} 

$first_name = $_POST ['first_name'];
$last_name = $_POST ['last_name'];
$email_address = $_POST ['email_address'];
$info = $_POST ['info'];


$first_name = stripslashes($first_name);
$last_name = stripslashes($last_name);
$email_address = stripslashes($email_address);
$info = stripslashes($info);


$sql = mysql_query("UPDATE users SET first_name='$first_name' AND last_name='$last_name'");
{
header("Location: view_info.php");
}


   ?>

My problem is mostly on the SET command in the query. It will update the first_name, but not the other fields that I need.
Any suggestions??

Thanks,
    -Blake

[planetsim]

Instead of

$sql = mysql_query("UPDATE users SET first_name='$first_name' AND last_name='$last_name'");

Try this

$sql = mysql_query("UPDATE users SET first_name='$first_name', last_name='$last_name'");

Should work

[batman]

Thank you so much. I have no clue why I didn't catch that.

-Blake