Re: [PHP] determining number of rows in a mysql table

[Miles Thompson]

select count(*) from tablename

Miles

At 12:12 PM 3/30/2004 +1000, Chris Wagner wrote:
this should be easy...

how would one go about determining the number of rows in a mysql table,
without actually wasting the time of querying for *.
is this the best way?

$result = mysql_query('SELECT * FROM tablename');
$num_rows = mysql_num_rows($result);
does this actually take up time searching?

thanks.

--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php