Display Record Count in Output

Hello:

How would I display the number of records returned for a MySql query in the
output? Thanks

David

Re: Display Record Count in Output

C. David Rossen wrote:
> Hello:
>
> How would I display the number of records returned for a MySql query in the
> output? Thanks
>

have a look at mysql_num_rows()

Regards
Stefan

> David
>
>

Re: Display Record Count in Output

$count = mysql_num_rows($result);

(where $result is the left side of the previous MySQL query)

Kitty
http://OpenSkyWebDesign.com

Re: Display Record Count in Output

C. David Rossen wrote:
> Hello:
>
> How would I display the number of records returned for a MySql query in the
> output? Thanks
>
> David
>
>
Would count() also work?

"SELECT count(*) FROM table WHERE blablabla";