RE: [PHP-DB] Mysql Function to display number of records

use the offset parameter $offset = 0; //and is set from the application SELECT * FROM blah WHERE something<>0 LIMIT $offset , 5; bastien

From: jovanross@msn.com (Jovan Ross) To: php-db@lists.php.net Subject: [PHP-DB] Mysql Function to display number of records Date: 2 Nov 2004 20:28:41 -0000 I have a query that uses a LIMIT clause. Let's say it looks like this: SELECT * FROM blah WHERE something<>0 LIMIT 5; Ok, now my table really has 20 rows that satisfy the WHERE statement but I only retrieved 5. There was a function/statement that I could use to find out the total number of rows that would have been returned had I not used the LIMIT clause. Does anyone know what the statement was? I forget. Yes, I'm using PHP btw. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php