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
*/
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
