Postgres Pro
Downloads
Home   >   mailing lists

Re: Retrieving result of COUNT(*) with PHP - Mailing list pgsql-php

From Gavin M. Roy
Subject Re: Retrieving result of COUNT(*) with PHP
Date
Msg-id 5b599cc10703281418j65c65ce7g537c7cc7fb32cbc5@mail.gmail.com
Whole thread Raw
In response to Re: Retrieving result of COUNT(*) with PHP  (Mihail Mihailov <Mihail.Mihailov@uta.fi>)
List pgsql-php
Tree view

On 3/28/07, Mihail Mihailov <Mihail.Mihailov@uta.fi> wrote:

Another way to calculate number of rows in the result is to use
pg_num_rows function.
$res = pg_query("SELECT COUNT(*) AS result_count FROM etc. WHERE etc.");
$count = pg_num_rows($res);

I dont think this will work as expected.  PostgreSQL will return 1 row and your $count var will be 1.  If you do SELECT * FROM it would return the proper result.  Not very effective for speed though.

http://www.varlena.com/GeneralBits/120.php has some good suggestions for dealing with count(*) speed issues.

Gavin


pgsql-php by date:

Previous
From: Frank Bax
Date:
Subject: Re: Retrieving result of COUNT(*) with PHP
Next
From: Andy Shellam
Date:
Subject: Re: Retrieving result of COUNT(*) with PHP