Query error
Posted: Fri Nov 12, 2004 8:08 am
I want to UPDATE a table called "imagen", the values from the column "orden", but I'm making something worng:
this is the output error:
Someone knows how can I fix the query?
Alvaro
Code: Select all
mysql_query("UPDATE imagen SET orden IN(".$losVal.") WHERE PicNum LIMIT 1")Code: Select all
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 'IN 9,1 WHERE PicNum LIMIT 1' at line 1Alvaro