Problem using PEAR::DB

From: 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

« previous php.pear.general (#8058) next »