On Fri, Jan 2, 2009 at 10:11 AM, Marc Fromm <[email protected]> wrote: > If I gather the sql results with this code > $results = pg_query($dbconn,$query); > > I can check if there is no returned data with this code > $rows = pg_fetch_assoc($result); > > but if I then use a while loop to display data (if there is data returned) > with this code > while ($row = pg_fetch_array($result)){ . . . } > > I have to execute this code a second time before the while loop > $results = pg_query($dbconn,$query); > > If I do not execute the $results line a second time the while loop does not > work properly. > > Why is $results loosing its value when it hits the while loop?
It shouldn't be. Got a complete, short sample that does this? -- Sent via pgsql-admin mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
