Re: Query refuses to recurse all rows

Chris wrote:

$numrows1 = pg_numrows($result1); $row = 0; do { $myrow = pg_fetch_array($result1, $row);

<snip>

$numrows2 = pg_numrows($result2); $row = 0; do { $myrow = pg_fetch_array($result2, $row);

You're overwriting your variables. $myrow from result 1 is being killed off when it gets into the $myrow loop from result 2.

Yeah, what Chris said! When you are looping inside another piece, make sure to change up all your variables. use a $j inside an $i, a $l inside a $k, $rowa inside a $row Woulda saved yourself a day of playing... Remember, the variable scope changes inside a function or class, but outside of that they pretty much run the whole length of the script. HTH, Wolf