QUERY error

[ratamaster]

I want to UPDATE a table called "imagen", the values from the column "orden", but I'm making something worng:

mysql_query("UPDATE imagen SET orden IN(".$losVal.") WHERE PicNum LIMIT 1")

this is the output error:

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 1

Someone knows how can I fix the query?

Alvaro

[aconway]

I'm fairly new at php and mysql myself, but I would check the value in $losVal.

It looks like you are using a comma instead of a period, which may confuse mysql in the query.

I'm sorry about being so vague, but maybe this was helpful. 🙂

[devinemke]

which record do you want to update? which PicNum?

UPDATE imagen SET orden = '$losVal' WHERE PicNum = '???'

fill in the ??? with the specific record to want to update