nested mySQL queries

[Anon]

I want to nest mySQL queries such that the result from one query are used to form the Select of the 2nd query. (nested While loops).

In Perl, you can simply create different database handles so that the querys don't overwrite each other. (Using the DBI module)

i.e.

while ($ary = $sth->fetchrow_array()) {
$sth_2->execute($ary[0]);
while ($ary_2 = $sth_2->fetchrow_array()) {
... perform routine here...
}
}

How do I set something up in a similar manner using PHP? (Please, no suggestions to break up the routine. )

I've tried doing:

$query_1 = mysql_query($select_1);
$query_2 = mysql_query($select_2);

but that doesn't work.

[Anon]

It should work:

1) $query_1=mysql_query($select_1);
2) loop through $query_1, getting $something from each row
3) use $something to build $select_2
4) $query_2=mysql_query($select_2);
5) loop through $query_2
6) Do stuff
7) end both loops

What's happening instead? Can't diagnose the problem if we can't see the symptoms.