update

Hello, Newbie question. And can the same SQL portion of the code be written something like... query= "UPDATE taablename SET (username, email, location) VALUEs( $username, $email, $location)"; Any reason why this Update command would not execute? // BUILD AND EXECUTE QUERY TO SAVE USER INFO INTO DATABASE TABLE query = "UPDATE forumUsers SET username = '$name' WHERE userID = '$id'"; result = @mysql_query($query); query2 = "UPDATE forumUsers SET email = '$emai' WHERE userID = '$id'"; result2 = @mysql_query($query2); query3 = "UPDATE forumUsers SET Location = '$loc' WHERE userID = '$id'"; result3 = @mysql_query($query3); / INFORM FLASH OF SUCCESS print "&/:result=Updated Thanks"; // CLOSE LINK TO DATABASE SERVER ysql_close($link); ?> Ike