> ie start at record 10 and show the next 10. But this delivers back "10" > as the $num_rows variable, when I want the total number of rows. > > I don't really have to complete two querys to get the appropriate values > do I?
mysql_num_rows just counts the amount of rows in a query, so if you only selected 10 rows, it will return 10. If you want to count all the rows in the table, its best to use the COUNT() function SELECT COUNT(*) FROM table -------------- Adam Alkins http://www.rasadam.com -------------- -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php