select count(*) from tablename --- Chris Wagner <[EMAIL PROTECTED]> 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 >
__________________________________ Do you Yahoo!? Yahoo! Finance Tax Center - File online. File on time. http://taxes.yahoo.com/filing.html -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php