Re: determining number of rows in a mysql table
| From: | Daniel Guerrier | Date: | Tue, 30 Mar 2004 02:22:09 +0000 |
| Subject: | Re: determining number of rows in a mysql table | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-181761@lists.php.net to get a copy of this message | ||
select count(*) from tablename
--- Chris Wagner <chris.t.wagner.1@ohiou.edu> 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