MySQL Forums
Forum List  »  PHP

Update Syntax
Posted by: James Phelan
Date: January 31, 2006 04:41AM

Hi

Can anyone help me Im a beginer to php and mysql and Im trying to update a table using the following code, all the values are sent from a html form.

$in = mysql_query("UPDATE staff SET (name,office,department,telephone,email)
VALUES ('$fullname','$office','$department','$telephone','$email') WHERE staff_id == "$staff_id" ");

I would be very gratefull for any help.

James Phelan

Options: ReplyQuote


Subject
Written By
Posted
Update Syntax
January 31, 2006 04:41AM
January 31, 2006 06:09AM
January 31, 2006 10:26AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.