Re: Additional query for number of records in table

afan@afan.net wrote:

hi, I have query to select products for specific category from DB, something like: SELECT prod_id, prod_name,... FROM products LIMIT $From, $To where $From and $To values depend of on what page you are. let say there are 100 products and I'm listing 25 products per page. for page 1 $From=0, $To=24. for page 2 $From=25 and$To=49, etc. works fine. though, to calculate how many pages I have I need total number of records. do I have to run first a query (something like SELECT COUNT(*) as NoOfRecords FROM products) and then query above or there is solution to have both info using one query? as a solution, I can run a query to grab all records and then list just 25 products but I think it's not so smart idea :) thanks for any help. -afan I would say the select count(*) from ... query would be a fairly low cost query.

Perhaps you could store off the number of rows in a session variable so you don't have to execute the count query when you move to the next page. -B