dough boy Posted April 2, 2007 Share Posted April 2, 2007 I am pretty sure I know the answer, but I am anal anyways... I need to setup a "paging" system so that only X records will be shown on a page at a time. Clicking next page, shows the next X and so on. This only works if you know the total number of pages (total records/X per page). My question is simple. Can you get with 1 query the desired recordset (i.e. using limit 10,20), but for the ADoDB (adodb.sourceforge.net) object to know how many were possible? I hate doing 2 queries, especially on something so "small". Thanks for the help! Link to comment https://forums.phpfreaks.com/topic/45300-adodb-total-recordset-size/ Share on other sites More sharing options...
dough boy Posted April 2, 2007 Author Share Posted April 2, 2007 Any takers? To put it more simply, I want to be able to return a portion of a recordset (using limit) but then also have the recordset contain the total records possible. I guess I could do it with a subquery. Thanks. Link to comment https://forums.phpfreaks.com/topic/45300-adodb-total-recordset-size/#findComment-220200 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.