How do I show the result of this query using Joomla pagination?

Question

How do I show the result of this query using Joomla pagination?

What can I do to display the result of this query in the front using Joomla pagination?

<?php
  $database =& JFactory::getDBO();
  $sql = 'SELECT * FROM #__no_entreprise';
  $database->setQuery( $sql );
  $rows = $database->loadObjectList();
?

0

php joomla pagination

tima 06 May '09 at 21:16

a source to share

1 answer

Gabriel sosa · Answer 1 · 2009-05-07T03:05:05+0000

See Joomla docs - Using JPagination in your component . In short, something like this:

$pageNav = new JPagination( $database->loadResult(), $lim0, $lim );
echo $pageNav->getListFooter();

How do I show the result of this query using Joomla pagination?

More articles: