Nested query problem, sorta odd

[Anon]

I have a while loop that gets the output, row by row, of a query. Within the loop I create a new query and execute it on the data from the first.

Simple, right?

Tried pconnect, separate connections, same connection....still get the old "Supplied argument is not a valid MySQL result resource" error.

Any ideas?

[Anon]

Do a join instead. If you need more help, post more details.

[edwardsbc]

Don't use the same resource/result identifier as the first query (see $r1 and $r2 below).

$r1=odbc_exec($handle,$sql);
...
while(odbc_retch_row($r1)) {
...
$r2=odbc_exec($handle,$newsql);
}

Lars is right though, if you can do it with a join it will be much faster. A join won't always work though...