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
:30 PM
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED]
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
, 2002 1:35 PM
To: 'Chris Knipe'; [EMAIL PROTECTED]; [EMAIL PROTECTED];
[EMAIL PROTECTED]
Subject: RE: [PHP] why do i get this error please tell me?
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
:[EMAIL PROTECTED]]
Sent: Saturday, August 31, 2002 1:35 PM
To: 'Chris Knipe'; [EMAIL PROTECTED]; [EMAIL PROTECTED];
[EMAIL PROTECTED]
Subject: RE: [PHP] why do i get this error please tell me?
Yep, figured it just now, thanks anyway, ahhh.. You'd thing they put
reserved names right besides the damn
. PHP != MySQL.
-Original Message-
From: victor [mailto:[EMAIL PROTECTED]]
Sent: Saturday, August 31, 2002 1:35 PM
To: 'Chris Knipe'; [EMAIL PROTECTED]; [EMAIL PROTECTED];
[EMAIL PROTECTED]
Subject: RE: [PHP] why do i get this error please tell me?
Yep, figured it just now, thanks anyway
5 matches
Mail list logo