[SOLVED] Update Trouble

[unkwntech]

This query is not working:

UPDATE products SET name='Sesame Chicken Salad', desc='', price='12.99', status='active', shipping='0.00', section='american', text='BIG LONG STRING' WHERE id='4'

 

The table looks like this:

+----------+--------------+------+-----+----------+----------------+
| Field    | Type         | Null | Key | Default  | Extra          |
+----------+--------------+------+-----+----------+----------------+
| id       | int(25)      | NO   | PRI | NULL     | auto_increment |
| name     | varchar(250) | NO   |     |          |                |
| desc     | text         | NO   |     | NULL     |                |
| price    | decimal(9,2) | NO   |     | 0.00     |                |
| status   | varchar(200) | YES  |     | inactive |                |
| shipping | decimal(5,2) | NO   |     | 0.00     |                |
| section  | varchar(250) | YES  |     | NULL     |                |
| text     | text         | NO   |     | NULL     |                |
+----------+--------------+------+-----+----------+----------------+

[revraz]

What is the mysql error?

[unkwntech]

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='', price='12.99', status='active', shipping='0.00', section='american', te' at line 1

 

 

SQL version is up to date as of yesterday Aug 10th.

ID 4 does exits.

Adding data to desc='' does not help.

[revraz]

DESC is a mysql reserved word (meaning Decending for sorting).  Change the fieldname and it should work fine.

[unkwntech]

WOW,..... thx