Re: Number of rows reurned?
| From: | Jason Wong | Date: | Sun, 20 Jan 2002 17:52:49 +0000 |
| Subject: | Re: Number of rows reurned? | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-81278@lists.php.net to get a copy of this message | ||
On Monday 21 January 2002 01:45, Daniel Alsén wrote:
> Hi,
>
> how can i get the number of rows reuturned by this query?
>
> $sql = "select date from statistik where shooter='$shooter_login' group by
> date";
>
> I want to add a page function and limit the returned rows on each page -
> but i can´t get the total number of rows.
Check out the relevant chapter in the manual for the db that you're using.
Some dbs have a function returning the number of rows.
If you're using MySQL then mysql_num_rows() is what you want.
--
Jason Wong -> Gremlins Associates -> www.gremlins.com.hk
/*
If a man has talent and cannot use it, he has failed.
-- Thomas Wolfe
*/