Re: [PHP] PHP-mysql: affected rows

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 determin

RE: [PHP] PHP-mysql: affected rows

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, 2