php的mysql更新语句怎么写_PHP / MYSQL更新语句建议

这应该工作

if($_POST['usubmit']=='Update')

{

$Uerr = array();

if (!$_POST['fullname'] || !$_POST['myusername'])

{

$Uerr[] = '» Name or Email must be filled in!';

}

if (!checkEmail($_POST['myusername']))

{

$Uerr[]='» Your email is not valid!';

}

// If there are no errors

if(!count($Uerr))

{

/* Now we will check if username is already in use or not */

$queryuser=mysql_query("SELECT * FROM customer WHERE email='" . mysql_real_escape_string($_POST["myusername"]) . "' AND cus_id !=" . $cus_id(mysql_real_escape_string));

$checkuser=mysql_num_rows($queryuser);

if($checkuser != 0)

{

$Uerr[]='» Sorry this email is already registered!';

}

else

{

$updateDetails = mysql_query("UPDATE customer SET

name = '" . mysql_real_escape_string($_POST["fullname"]) . "',

dob = '" . mysql_real_escape_string($_POST["dob"]) . "',

address = '" . mysql_real_escape_string($_POST["address"]) . "',

email = '" . mysql_real_escape_string($_POST["myusername"]) . "',

telephone = '" . mysql_real_escape_string($_POST["telephone"]) . "'

WHERE cus_id = '$cus_id'");

if ($updateDetails)

$_SESSION['Umsg']['Ureg-success']="» Your details have been updated successfully!";

else {

$Uerr[]='» error updating your account'.mysql_error();

}

}

}

if(count($Uerr))

{

$_SESSION['Umsg']['Ureg-err'] = implode('
',$Uerr);

}

header("Location: account.php");

exit;

}