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]

Reply via email to