Re: determining number of rows in a mysql table

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