Received: from localhost (maia-2.hub.org [200.46.204.187]) by postgresql.org (Postfix) with ESMTP id D6A8A9FBB45 for ; Thu, 29 Mar 2007 10:27:42 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.187]) (amavisd-maia, port 10024) with ESMTP id 72482-03-3 for ; Thu, 29 Mar 2007 10:27:16 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from tomts35-srv.bellnexxia.net (tomts35.bellnexxia.net [209.226.175.109]) by postgresql.org (Postfix) with ESMTP id BA7089FB755 for ; Thu, 29 Mar 2007 10:27:12 -0300 (ADT) Received: from toip34-bus.srvr.bell.ca ([67.69.240.35]) by tomts35-srv.bellnexxia.net (InterMail vM.5.01.06.13 201-253-122-130-113-20050324) with ESMTP id <20070329132707.MGGS1680.tomts35-srv.bellnexxia.net@toip34-bus.srvr.bell.ca> for ; Thu, 29 Mar 2007 09:27:07 -0400 Received: from toroon01-1177844104.sdsl.bell.ca (HELO [192.168.2.97]) ([70.52.121.136]) by toip34-bus.srvr.bell.ca with ESMTP; 29 Mar 2007 09:27:07 -0400 X-IronPort-Anti-Spam-Filtered: true X-IronPort-Anti-Spam-Result: AgAAAPtbC0ZGNHmI/2dsb2JhbAAN User-Agent: Microsoft-Entourage/10.1.6.040913.0 Date: Thu, 29 Mar 2007 09:27:22 -0400 Subject: Re: Retrieving result of COUNT(*) with PHP From: Lynna Landstreet To: PgSQL-PHP Mailing List Message-ID: In-Reply-To: Mime-version: 1.0 Content-type: text/plain; charset="US-ASCII" Content-transfer-encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200703/65 X-Sequence-Number: 3777 Hi there, OK, in tinkering around with this further, I seem to have solved it, and everything is working now - thought I'm still not 100% sure why it wasn't before! I did find an error in the count_query string at one point that would have accounted for it bringing up a different result than the actual number of results the search query brought in - but I'm reasonably sure at some point during this I had copied and pasted the count query into phpPgAdmin and gotten a result that was consistent with the search query, but then got a different result in my PHP script. Still not sure how that happened... But anyway, the important part is it's working now. Thanks to everyone who replied! Lynna -- Spider Silk Design - http://www.spidersilk.net 509 St Clair W Box 73576, Toronto ON Canada M6C 1C0 Tel 416.651.2899 - Toll Free 1.866.651.2899 - Cell 416.873.9289