include "include/newssearch.php";
if (empty($offset)) $offset=0;
$current=$offset;
$query="SELECT * FROM $kattable WHERE katid LIKE '$kat'";
$result=mysql_db_query($dbname,$query,$conn);
$data=mysql_fetch_row($result);
$katname=$data[1];
$query3="SELECT * FROM $sitetable WHERE kat=$kat and active='1'";
$result3=mysql_db_query($dbname,$query3,$conn);
$total=mysql_numrows($result3);
echo"
Rubrik: $katname ($total Einträge) |
|
";
$query="SELECT * FROM $sitetable WHERE kat=$kat and active=1 ORDER BY sitename LIMIT $offset,$maxrows";
$result=mysql_db_query($dbname,$query,$conn);
$num = $offset+1;
while($data2=mysql_fetch_row($result))
{
$indatum = $data2[9];
include("include/time.class.php");
if ($data2[9] > date("Y-m-d", (time()-$timenew)))
{
$neu=" neu ";
}
else {
$neu = "";
}
echo"
$num. $data2[1]$neu ($data2[7] Klicks) |
$data2[4] |
URL: $data2[2] Eintrag: $pretty_time Link defekt? | ";
$num++;
}
echo " ";
$weiterzurueck ="Seite: [ ";
if ($total == 0 ) $weiterzurueck .="keine ]";
elseif ($total > 0){
$zaehlblock = $maxrows;
$offset = 0 - $zaehlblock;
$maxrows = $zaehlblock;
$bloecke = $total / $zaehlblock;
$bloecke = $bloecke + 1;
$count =1;
while ( $count < $bloecke){
$offset = $offset + $zaehlblock;
if ($offset == $current) {
$weiterzurueck .="$count ";
}
else {
$weiterzurueck .= "$count ";
}
$count++;
}
$weiterzurueck .= " ]";
}
echo "$weiterzurueck | ";
include "include/footer.inc";
?>
|
|
include "include/rechts.php"; ?> |