RE: [PHP] why do i get this error please tell me?
| From: | victor | Date: | Sat, 31 Aug 2002 17:34:35 +0000 |
| Subject: | RE: [PHP] why do i get this error please tell me? | ||
| References: | 1 | Groups: | php.db php.general |
| Request: | Send a blank email to php-general+get-114770@lists.php.net to get a copy of this message | ||
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 > www.argilent.com
-----Original Message-----
From: Chris Knipe [mailto:savage@savage.za.org]
Sent: Saturday, August 31, 2002 1:30 PM
To: victor@argilent.com; php-db@lists.php.net; php-general@lists.php.net
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
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.
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
______________________________________________________________________
Post your free ad now! http://personals.yahoo.ca