quick question on UPDATE

[altctrldel]

mysql_query("UPDATE tblrepair SET ( mgt_id,rep_status,rep_notes)                                              VALUES('$mgtid','$decision','$comments') WHERE rep_id='$rid'") or die ("Error in registration sql:" . mysql_error());

I always get a You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '( mgt_id,rep_status,rep_notes) '.

I already checked all my variables and they all have data in them.

thanks

 

[sleipnir214]

I think you have the syntax of the UPDATE and SELECT queries confused.

I.A.W

http://dev.mysql.com/doc/refman/4.1/en/update.html

, UPDATE queries take the form:

UPDATE tablename SET columname1=value1, columname2=value2 WHERE somecolumn = somevalue



Want the best answers? Ask the best questions! TANSTAAFL!

 

[altctrldel]

yup thanks got it na awhile ako. trial n error hehe