> 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()
SELECT COUNT(*) FROM table
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php