if ($tipo_noticia!="") {
$noticia_print = $d_News." - ".$noticia_tipo_show;
}
else {
$noticia_print = $d_News;
}
?>
############################################################################################################
##query
$sql = "SELECT id, DATE_FORMAT(date,'%d-%m-%Y'), headline_".$sLang.", quelle FROM new_noticias WHERE (valido=\"S\" OR valido=\"B\" OR VALIDO=\"D\") AND headline_".$sLang." != ''";
if ($tipo_noticia!="") {
$sql .= " AND tipo='$tipo_noticia'";
}
$sql .= " ORDER BY date DESC, id DESC";
//echo $sql;
$pager = new PS_Pagination($conn, $sql, 20, 10, "nLang=$nLang&tipo_noticia=$tipo_noticia");
/*
* 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 "".$row[1]." | ";
print "".$row[2]." (".$row[3].") |
";
}
?>
print "
";
echo $pager->renderFullNav();
print "
";
?>