DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma;
	h=message-id:date:from:to:subject:cc:in-reply-to:mime-version
	:content-type:content-transfer-encoding:content-disposition
	:references;
	b=UBy+iYSKhiJlYYElTIN66GsnOravU22Pe8b/o8aFI+RVfYEJRdPJvdQ+Uth13Sw7Ob
	D3qsYefby40vH9C3k4zrFiph8F7qgf4nLYL853vtM4ZyhPeIPCgq21LMQRTn0fuEPE05
	/ANSRjMoxxC3CmcfqQL9N+K4XY6F9bG5DCXII=
Message-ID: <dcc563d10901020928g6227a7fev357dddc9489f2b24@mail.gmail.com>
Date: Fri, 2 Jan 2009 10:28:42 -0700
From: "Scott Marlowe" <scott.marlowe@gmail.com>
To: "Marc Fromm" <Marc.Fromm@wwu.edu>
Subject: Re: access data in php
Cc: "pgsql-admin@postgresql.org" <pgsql-admin@postgresql.org>
In-Reply-To: 
 <B0D7C0A3F35FE144A70312D086CBCA9B0213E18F15@ExchMailbox2.univ.dir.wwu.edu>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
References: 
 <B0D7C0A3F35FE144A70312D086CBCA9B0213E18F15@ExchMailbox2.univ.dir.wwu.edu>

On Fri, Jan 2, 2009 at 10:11 AM, Marc Fromm <Marc.Fromm@wwu.edu> 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?