Re: Native Error 1064 with PEAR DB and mysql
| From: | Henrik Karlsson | Date: | Thu, 01 Jan 1970 00:00:00 +0000 |
| Subject: | Re: Native Error 1064 with PEAR DB and mysql | ||
| References: | 1 | Groups: | php.pear.general |
| Request: | Send a blank email to pear-general+get-2355@lists.php.net to get a copy of this message | ||
On Fri, 20 Sep 2002, Stanislav Okhvat wrote:
> Do you really have to quote table "person" in the SQL statement. I
> don't think this is necessary and phpMyAdmin could handle the issue
> while PEAR doesn't. Try it without the quotes.
I've tried that but it doesnät help. The error is still there:
********
'SELECT personID, firstname, surname, title FROM person WHERE personId>0
ORDER BY surname' [nativecode=1064 ** You have an error in your SQL syntax
near ''SELECT personID, firstname, surname, title FROM person WHERE
personId>0 ORDER B' at line 1]
DB Error: syntax error
********
--
Henrik Karlsson | www.henriks.org
Studying Automation Engineering | ICQ: UIN 2785561
at Chalmers University of Technology | +46-707-99 50 31
"Coughlin's law - anything else is always something better."