Re: [PHP] Query refuses to recurse all rows

2008-05-28 Thread celtic
Hi Jim, Actually, after I got the code working, I eliminated the 'exit' and skipped the empty query instead to the next block. Ahh! That cryptic header relocate: If the db conn or code is buggy fails, it redirects to a nice page telling the user that the db 'Is down for maintenance' or somesu

Re: [PHP] Query refuses to recurse all rows

2008-05-28 Thread Jim Lucas
[EMAIL PROTECTED] wrote: Hi, In the following code, only the first row from query1 displays along with the display stuff from query3. The problem: query1 refuses to recurse to the next and following rows. It appears that the sub-queries in the main query cause the $row++; not to work. Is

Re: [PHP] Query refuses to recurse all rows {RESOLVED]

2008-05-28 Thread celtic
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: >

Re: [PHP] Query refuses to recurse all rows

2008-05-28 Thread Wolf
Chris wrote: $numrows1 = pg_numrows($result1); $row = 0; do { $myrow = pg_fetch_array($result1, $row); $numrows2 = pg_numrows($result2);

Re: [PHP] Query refuses to recurse all rows

2008-05-28 Thread Chris
> $numrows1 = pg_numrows($result1); > $row = 0; > do > { > $myrow = pg_fetch_array($result1, $row); > $numrows2 = pg_numrows($result2); >