develooper Front page | perl.beginners | Postings from December 2002

dbi mysql question

Thread Next
Dan Muey
December 31, 2002 11:44
dbi mysql question
Message ID:
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
$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 )

Thread Next Perl Programming lists via nntp and http.
Comments to Ask Bjørn Hansen at | Group listing | About