PHP-mysql: affected rows
| From: | Victor Spång Arthursson | Date: | Fri, 31 May 2002 12:15:32 +0000 |
| Subject: | PHP-mysql: affected rows | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-100079@lists.php.net to get a copy of this message | ||
Hi!
If I use the "LIMIT 0, 9" at the end of a SQL-query, mysql will only return the first 9
records from the database... But to determine wether or not to print out the "next page",
I need to know the total number of records matching the query... Is there a way of doing this
without having to do a new query with COUNT in it..?
Sincerely
Victor