Yep, figured it just now, thanks anyway, ahhh.. You'd thing they put
reserved names right besides the damn mysql command in the manual. Alas
it shall not be so.

- Victor >

-----Original Message-----
From: Chris Knipe [mailto:[EMAIL PROTECTED]] 
Sent: Saturday, August 31, 2002 1:30 PM
Subject: Re: [PHP] why do i get this error please tell me?

> You have an error in your SQL syntax near 'order=1 WHERE ID='2'' at
> 2

ORDER is a reserved word in MySQL.

Change the query and escape order aswell

'order'='1' WHERE ID='2'

Or, rename the order column to something else.

PHP General Mailing List (
To unsubscribe, visit:

Post your free ad now!

PHP Database Mailing List (
To unsubscribe, visit:

Reply via email to