############################################################################################################
if ($category_id==0) {
print "
".$d_link_xchange."
";
}
else {
##query cats
$cats = new link_cat($id,$name,$desc,$activo);
$cats->showCat($category_id,$sLang);
//print "
".$cats->name."
";
print "
".$cats->name."
";
print "
";
## query links for corresponding cat
$sql = "SELECT id, url, name, desc_".$sLang.", banner, activo FROM links WHERE cat_id='".$category_id."' AND (activo='S' or ACTIVO='D' OR activo='B') ORDER BY name ASC";
$pager = new PS_Pagination($conn, $sql, 20, 10, "nLang=$nLang&category_id=$category_id");
/*
* Enable debugging if you want o view query errors
*/
$pager->setDebug(true);
/*
* The paginate() function returns a mysql result set
* or false if no rows are returned by the query
*/
$rs = $pager->paginate();
if(!$rs) die(mysql_error());
while($row = mysql_fetch_row($rs)) {
print "";
//print "• ";
print "".$row[2]."";
if ($row[4]!="") {
print " ";
print "";
}
if ($row[3]!="") {
print " ".$row[3]." |
";
}
}
}
?>
print "
";
echo $pager->renderFullNav();
print "
";
?>