SQL statement trouble 1

[BettyJo50]

HI!

Could someone please tell me what is wrong with my SQL statement?

$SQL="UPDATE umcritsurv WHERE $fldAuto=id (IQ_Use_Q9, etc) VALUES ('$IQ_Use_Q9', '$etc')";

This is the error I get:

ERROR: You have an error in your SQL syntax near 'WHERE =id (IQ_Use_Q9, Etc' at line 1 UPDATE umcritsurv WHERE =id (IQ_Use_Q9) etc.....

Thank you!!

 

[sleipnir214]

Several things. Most notably, the "VALUES" clause is only available in an INSERT query, not an UPDATE query. Also, the WHERE clause comes at the end of the query.

In an UPDATE query is of the form:

UPDATE tablename SET columnname = value, columnname = value WHERE somecondition

See MySQL online documentation on the UPDATE query

Want the best answers? Ask the best questions:

http://www.catb.org/~esr/faqs/smart-questions.html

TANSTAAFL!!

 

[BettyJo50]

Thanks for your help!!!