Quote:
# Database Query
$per_page = $ag_perpage;//nb de announcement per page

$database->setQuery($query1);

$connected = $database->query();
//$rows = $database->loadObjectList();

if(!isset($pageno))
{

$pageno = 1;
}
$prev_page = $pageno - 1;
$next_page = $pageno + 1;

// Set up specified page

$page_start = ($per_page * $pageno) - $per_page;
$num_rows = $database->getNumRows($connected);


if ($num_rows $num_pages) || ($pageno < 0)) {
echo "You have specified an invalid page number";
return false;
}

$sql_msg_per_page = $query1. " LIMIT $page_start, $per_page";

$database->setQuery($sql_msg_per_page);
$res = $database->query();


if($connected)
{
$rows = $database->loadObjectList();

$subtitle = (!isset($sorting) || $sorting == '') ? 'Viewed' : _BEVERAGE_VWS_AVG_TOTAL_USERS_VOTE;