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 > > -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php