Received: from localhost (maia-4.hub.org [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 46B049FBBB4 for ; Wed, 28 Mar 2007 18:43:10 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 55483-04 for ; Wed, 28 Mar 2007 18:43:07 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from skynet.simkin.ca (skynet.simkin.ca [72.51.27.117]) by postgresql.org (Postfix) with ESMTP id 1A8FD9FBAD5 for ; Wed, 28 Mar 2007 18:43:07 -0300 (ADT) Received: from crecy.medialogik.com (ah.medialogik.com [72.51.27.120]) (using TLSv1 with cipher DHE-RSA-AES256-SHA (256/256 bits)) (No client certificate requested) by skynet.simkin.ca (Postfix) with ESMTP id C49784A33 for ; Wed, 28 Mar 2007 14:43:05 -0700 (PDT) From: Alan Hodgson Organization: Simkin Network Consulting To: pgsql-php@postgresql.org Subject: Re: Retrieving result of COUNT(*) with PHP Date: Wed, 28 Mar 2007 14:43:05 -0700 User-Agent: KMail/1.9.5 References: <20070329000511.qidyijwozuo0w0w4@imp3.uta.fi> <6b8c0db0703281431m4b14237es333e1d6152f124de@mail.gmail.com> In-Reply-To: <6b8c0db0703281431m4b14237es333e1d6152f124de@mail.gmail.com> MIME-Version: 1.0 Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: quoted-printable Content-Disposition: inline Message-Id: <200703281443.05137@hal.medialogik.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200703/61 X-Sequence-Number: 3773 On Wednesday 28 March 2007 14:31, "Valent=C3=ADn Orfila"=20 wrote: > Where people this the way I do, count (*) could be slower > > $sql =3D "select * from TableName"; > $count =3D pg_query($sql); > $count =3D pg_num_rows($count); > ?> > > > I thing that's enough :) Apparently you have no tables with any real amount of data in them. =2D-=20 "It is a besetting vice of democracies to substitute public opinion for law." - James Fenimore Cooper=20