help paginating results? - Joomla! Forum - community, help and support

hi all...

i've built component runs query using joomla database objects , successfuly prints of results....

but set long , need simple pagination....

any pointers or suggestions?

thanks

mospagenav object (you might able find documentation searching through forums).  basically, here's need do:

1.  load defaults like:
    $limit = $mainframe->getuserstatefromrequest( "viewlistlimit", 'limit', $mosconfig_list_limit );
    $limitstart = $mainframe->getuserstatefromrequest( "view{$section}limitstart", 'limitstart', 0 );

2.  count total number of record using sql query
    $database->setquery("select count(*) ... ...");
    $total = $database->loadresult();

3.  create mospagenav object, , initialize required
    include_once( "includes/pagenavigation.php" );
    $pagenav = new mospagenav($total, $limitstart, $limit);

4.  append query getting actual data with:
    "limit " . $pagenav->limitstart . ", " . $pagenav->limit;


you'll want add page links @ bottom of html generated list.  use like:
 
   
     
   
   
     
     
     
   
 

writepageslinks(); ?>
	writelimitbox(); ?>	writepagescounter()."\n"; ?>