Answer my own question. Yes it is possible, no problem. My problem was an obscure infinite loop. So nevermind! Thanks
Dan -----Original Message----- From: Dan Muey Sent: Tuesday, December 31, 2002 1:43 PM To: [EMAIL PROTECTED] Subject: dbi mysql question Does any one happen to know if it's possible to do a query within a query : For instance : This is for demonstartion purposes and is not executable code : prepare $sth ->$dbh... execute $sth ->$dbh $sth ->$dbh fetchrowarray { $sth2 ->$dbh prepare $sth 2->$dbh execute $sth 2->$dbh fetchrow array { do stuff } $sth2->$dbh } $sth ->$dbh finsih in other words do a query then for each row in the query ( IE before the first $sth is closed ) do another query ( Different handle $sth2 , because I already know that can cause poblems ) Thanks Dan -- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]