Re: PHP-mysql: affected rows
| From: | Chris Hewitt | Date: | Fri, 31 May 2002 15:14:46 +0000 |
| Subject: | Re: PHP-mysql: affected rows | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-100094@lists.php.net to get a copy of this message | ||
Victor,
I'd do the count first anyway. Then you know whether you need to put up the "next page" links or not.
HTH
Chris
Victor Spång Arthursson wrote:
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