Received: from localhost (maia-3.hub.org [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 83D459F9FDA for ; Sun, 3 Dec 2006 20:26:04 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-new, port 10024) with ESMTP id 10518-03 for ; Sun, 3 Dec 2006 20:25:56 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.4 Received: from nz-out-0102.google.com (nz-out-0506.google.com [64.233.162.238]) by postgresql.org (Postfix) with ESMTP id 59BF99F9F47 for ; Sun, 3 Dec 2006 20:26:00 -0400 (AST) Received: by nz-out-0102.google.com with SMTP id i11so1712110nzh for ; Sun, 03 Dec 2006 16:25:59 -0800 (PST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:user-agent:mime-version:to:cc:subject:references:in-reply-to:content-type:content-transfer-encoding; b=YQszpArQn8U3KH8FZaxxfU/g7ZMiQggcDCIVKJqgSgqpAnTQQAGr4iJofUnBBtAkaBkgnc70I6by56MFpN2BCwqRhPnFuoaaikRi3dc+w1e5mfovPYI2k9I+NEInUOkGEpUA9G4ikVbx17dEBTA4dPch2SGuXNaVsTATiT/+fC8= Received: by 10.64.241.3 with SMTP id o3mr11837951qbh.1165191958983; Sun, 03 Dec 2006 16:25:58 -0800 (PST) Received: from ?10.1.1.11? ( [203.217.18.65]) by mx.google.com with ESMTP id f17sm34088756qba.2006.12.03.16.25.57; Sun, 03 Dec 2006 16:25:58 -0800 (PST) Message-ID: <45736B17.3020909@gmail.com> Date: Mon, 04 Dec 2006 11:25:59 +1100 From: Chris User-Agent: Thunderbird 1.5.0.8 (Windows/20061025) MIME-Version: 1.0 To: Mag Gam CC: Randy Moller , pgsql-php@postgresql.org Subject: Re: HTML FORMS selected question References: <457358D9.4000404@gmail.com> <20061203232352.A93629F9F8D@postgresql.org> <1cbd6f830612031543w26cdb6e2s82f1b958009d1b7@mail.gmail.com> <45736235.6080302@gmail.com> <1cbd6f830612031600xb902e5fgf3eb485a8af59a@mail.gmail.com> In-Reply-To: <1cbd6f830612031600xb902e5fgf3eb485a8af59a@mail.gmail.com> Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200612/9 X-Sequence-Number: 3677 Mag Gam wrote: > Chris + Randy: > > Sorry, I may of forgetten to give you this: > $result = pg_query($dbconn, "select id,address from ip"); > > This is right before the: > $options=pg_fetch_array($result_ip); > > so, my $results is really all the ip addresses ($rows after I perform > the pg_fetch_array). > > I will add the var_dump to see it (never done it before, I will do some > googling :) ) After your query add it: $result = pg_query(....) var_dump($result); if that's not a "resource" then you have a problem with your query. Use pg_last_error to work it out. Inside your loop, add it: while ($row = pg_fetch_array($result)) { var_dump($row); } -- Postgresql & php tutorials http://www.designmagick.com/