No. Do one query with count(*), one with limit. If you're smart, you'll save the total amount in a session somewhere so you only have to do that query once, anyway.
---John Holmes... > -----Original Message----- > From: Victor Spång Arthursson [mailto:[EMAIL PROTECTED]] > Sent: Friday, May 31, 2002 8:16 AM > To: [EMAIL PROTECTED] > Subject: [PHP] PHP-mysql: affected rows > > 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 > > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php