[PHPLIB] count(*) on select From: Marc Tardif (intmktg <email protected>)
Date: 11/19/99

How can I use count(*) and determine how many records are returned?
I tried the following:
$db->query("select count(*) from table where one='two'");
if ($db->f("count")>0) $util->my_msg("no records");

I also tried using nf() and num_rows(), but none seem to return the
proper value of count(*). By the way, I'm using postgresql if that makes
a difference.

Thanks in advance,
Marc

-
PHP3 Base Library Mailing List. Send messages to <phplib <email protected>>.
To unsubscribe, send "unsubscribe" to <phplib-request <email protected>> in
the body, not the subject, of your message.