function showChronoContact($option) { global $mainframe; $limit = $mainframe->getUserStateFromRequest($option . '.limit', 'limit', $mainframe->getCfg('list_limit'), 'int'); $limitstart = $mainframe->getUserStateFromRequest($option . '.limitstart', 'limitstart', 0, 'int'); // count entries $database =& JFactory::getDBO(); $database->setQuery("SELECT count(*) FROM #__chrono_contact"); $total = $database->loadResult(); echo $database->getErrorMsg(); jimport('joomla.html.pagination'); $pageNav = new JPagination($total, $limitstart, $limit); # main database query $database->setQuery("SELECT * FROM #__chrono_contact ORDER BY id LIMIT {$pageNav->limitstart},{$pageNav->limit}"); $rows = $database->loadObjectList(); if ($database->getErrorNum()) { JError::raiseWarning(100, $database->stderr()); $mainframe->redirect("index2.php?option={$option}"); } HTML_ChronoContact::showChronoContact($rows, $pageNav, $option); }