Re: why do i get this error please tell me?
| From: | Chris Knipe | Date: | Sat, 31 Aug 2002 17:30:15 +0000 |
| Subject: | Re: why do i get this error please tell me? | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-114769@lists.php.net to get a copy of this message | ||
> You have an error in your SQL syntax near 'order=1 WHERE ID='2'' at line
> 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.