Re: Query refuses to recurse all rows {RESOLVED]

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Thanks Wolf and Chris,

That did the trick -- now I just have to clean up the order a bit.

Amazing how another's view can see the problem so clearly -- I was way too 
close, what with otehr coding - should've seen it!

Regards,
Andre
(celtic)

On Wednesday 28 May 2008, Wolf wrote:
> 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



-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


[Index of Archives]     [PHP Home]     [Apache Users]     [PHP on Windows]     [Kernel Newbies]     [PHP Install]     [PHP Classes]     [Pear]     [Postgresql]     [Postgresql PHP]     [PHP on Windows]     [PHP Database Programming]     [PHP SOAP]

  Powered by Linux