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]