RE: dbi mysql question

[Dan Muey]

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]