RE: [PEAR] Problem using PEAR::DB

> From: Martin Marques [mailto:martin@bugs.unl.edu.ar] > Sent: Friday, September 26, 2003 9:18 PM > El Vie 26 Sep 2003 11:46, Lukas Smith escribió: > > > From: Dennis Sterzenbach [mailto:dennis@darknoise.homeip.net] > > > Sent: Friday, September 26, 2003 4:42 PM > > > > > > 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;" > > > > this is called "batch querying" and it is not supported my mysql > > (frontbase and mssql support it though). > > Not only commertial databases support it. PostgreSQL too! Ah sorry I was referring more about a clean integration into the php ext. Both Frontbase and MSSQL ext have the ability to then move from one result set to the next to read the results Regards, Lukas