working with multiple result set

From: Date: Fri, 21 Mar 2003 19:58:17 +0000
Subject: working with multiple result set
Groups: php.pear.general 
Request: Send a blank email to pear-general+get-4365@lists.php.net to get a copy of this message
Hi all. At this time,I want to know how to work with multiple result set with PEAR. I have following simple query that returns two result set at once. select * from t_A; select * from t_B; In script file,I did following. require_once('DB.php'); $dsn = "pgsql://userA:mypasswd@localhost:5432t/mydb"; $db = DB::connect($dsn, true); $query = "select * from t_A;\n"; $query .= "select * from t_B"; $rs = $db->query($query); I expect that $rs will hold multiple result set and prepared function to work around them. But I could work with single result set that hold result set that executed by last "select" statement. Under ADO interface,result set object will hold multiple result set automatically and we can use NextRecordset function against result set object(with Microsoft ASP environment). Any idea? Thank you very much.

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