Update Query Help

[luciferc]

Server version: 5.0.45-community-log'

QUERY:

mysql_query(" UPDATE Products SET price='50',prim='25',stitle='25',desc='Hi I am a Query' WHERE title='TheBox' ") 

 

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 'desc='Hi' WHERE title='TheBox' at line 1

--Its susposed to change the products Desc Prim size, Second Title (For Show), and its Price where the title(item) is = the one you selected.

 

Table Layout

Id Oid title stitle desc price prim link prem salesmoney salesamount dofupdate msales

 

As soon as i add desc='Hi' it stops working w/ out it does fine. IDK what is wrong

desc = (desc  varchar(900)  latin1_swedish_ci)

 

I've tryed to put desc in a seperate statment or even put it at the begging of the statement still nothing.

 

I have no idea why is isn't working

[Barand]

DESC is an SQL reserved word. Don't use for column names.