Problem using PEAR::DB
| From: | Dennis Sterzenbach | Date: | Fri, 26 Sep 2003 14:41:48 +0000 |
| Subject: | Problem using PEAR::DB | ||
| Groups: | php.pear.general | ||
| Request: | Send a blank email to pear-general+get-8058@lists.php.net to get a copy of this message | ||
Hi,
I've got a problem using PEAR::DB.
I'm already used to the PEAR database abstraction layer,
but never before I stepped that much into detail of
MySQL and PEAR.
For me there's obviously no problem putting three queries
in one SQL string using phpMyAdmin, neither executing it
on shell.
But if I try to execute a 'simpleQuery($sql)' with an SQL
as follows:
$sql = "DELETE FROM logins WHERE uid=8;
DELETE FROM users_lists WHERE uid=8;
DELETE FROM users WHERE uid=8;"
I always catch a DB_Error:
db_error Object
(
[error_message_prefix] =>
[mode] => 1
[level] => 1024
[code] => -2
[message] => DB Error: syntax error
[userinfo] => DELETE FROM logins WHERE uid=8;
DELETE FROM users_lists WHERE uid=8;
DELETE FROM users WHERE uid=8;
[nativecode=1064 ** You have an error in your SQL syntax near ';
DELETE FROM users_lists WHERE
uid=8;' at line 1]
Any idea?
Thanks in advance.
Best Regards
Dennis Sterzenbach