connect();
if( isset($_GET['start']) && !empty($_GET['start']) )
$start = $_GET['start'];
else
$start = 0;
/***********************/
$db->query("SELECT count(*) as total
FROM ".$_SESSION['tablename']['listmodel_assoc']." la
LEFT JOIN ".$_SESSION['tablename']['services']." s ON ( la.ASSOC_SERVICE = s.ID )
WHERE s.ENABLED = 'Y'");
$nb_total_1 = $db->fetch_object();
$nb_total = $nb_total_1->total;
// define the defaults values
$nb_pages = ceil($nb_total/$nb_show);
$link = "index.php?page=".$page_name."&start=".$start;
if($nb_pages > 1)
{
$next_start = 0;
$page_list1 = '';
$page_list2 .= $previous." ".$next.'';
}
}
echo '
'.$title.'
';
echo $page_list1;
?>
query("SELECT la.ID as ID, la.NAME as NAME, s.SERVICE as SERVICE,
(SELECT COUNT(ID) FROM ".$_SESSION['tablename']['listmodel']." WHERE ID = la.ID) as CPT
FROM ".$_SESSION['tablename']['listmodel_assoc']." la
LEFT JOIN ".$_SESSION['tablename']['services']." s ON ( la.ASSOC_SERVICE = s.ID )
WHERE la.ASSOC_SERVICE IS NULL OR s.ENABLED = 'Y' ORDER BY la.NAME
LIMIT ".$start.",".$nb_show);
$color = "line1";
while($line = $db->fetch_object())
{
if($color == ' class="col"')
{
$color = '';
}
else
{
$color = ' class="col"';
}
?>
'.$title.'