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

dbi mysql question

Thread Next
From:
Dan Muey
Date:
December 31, 2002 11:44
Subject:
dbi mysql question
Message ID:
D6D77DB239A2004BB08A240E2E71460D08FA38@customer.infiniplex.net
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

Thread Next


nntp.perl.org: Perl Programming lists via nntp and http.
Comments to Ask Bjørn Hansen at ask@perl.org | Group listing | About