Hello,
this maybe more of a perl question then dbi, but not sure exactly how to
approach this. I have 4 separate queries:
$sql = |QUERY1|;
$arrayref_articles = $dbh->selectall_arrayref($sql);
$sql = |QUERY2|;
$arrayref_directory = $dbh->selectall_arrayref($sql);
$sql = |QUERY3|;
$arrayref_jobs = $dbh->selectall_arrayref($sql);
$sql = |QUERY4|;
$arrayref_insets = $dbh->selectall_arrayref($sql);
what I need to do is combine all 4 of these selectall_arrayref() into one array
ref and loop thru all the results. IE:
$allarrayref =
[$arrayref_articles,$arrayref_jobs,$arrayref_directory,$arrayref_insets];
But I don't think this approach works. what is the best way to combine all of
them into one arrayref so the single $allarrayref contains all results of the
combined arrayrefs ??
TIA
--
Mike(mickalo)Blezien
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Thunder Rain Internet Publishing
Providing Internet Solutions that work!
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
