[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

RE: [PHP] PHP-mysql: affected rows

, 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

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 determine