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

ent: 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 t

[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