[EMAIL PROTECTED] (Chris Wagner) wrote in
news:[EMAIL PROTECTED]:
> 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.
>
Try SELECT COUNT(*) FROM table AS numrows
Have a look at http://www.mysql.com/doc/en/GROUP-BY-Functions.html for more
info on how Count works.
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
