//politik
$empty_news=0;
$sql_news="SELECT `id`,`titel`,`date` FROM `artikel` WHERE `lokalnews` = '1' AND category='politik' ORDER BY `date` DESC";
$data_news=mysql_query($sql_news, $db);
while ($next_news = mysql_fetch_object ($data_news))
{
$date = date("d.m.y",$next_news->date);
$day = date("H:i",$next_news->date);
$empty_news++;
print "$date - $day ";
$next_id=$next_news->id;
$next_name=$next_news->titel;
print "";
secure($next_name);
print "
";
}
if(empty($empty_news))
{
print "Keine Artikel gefunden";
}
//else {
//print " Alle Artikel";
//}
?> |
//kultur
$empty_news=0;
$sql_news="SELECT `id`,`titel`,`date` FROM `artikel` WHERE `lokalnews` = '1' AND category='kultur' ORDER BY `date` DESC";
$data_news=mysql_query($sql_news, $db);
while ($next_news = mysql_fetch_object ($data_news))
{
$date = date("d.m.y",$next_news->date);
$day = date("H:i",$next_news->date);
$empty_news++;
print "$date - $day Uhr ";
$next_id=$next_news->id;
$next_name=$next_news->titel;
print "";
secure($next_name);
print "
";
}
if(empty($empty_news))
{
print "Keine Artikel gefunden";
}
//else {
//print "Alle Artikel";
//}
?> |
//SPORT
$empty_news=0;
$sql_news="SELECT `id`,`titel`,`date` FROM `artikel` WHERE `lokalnews` = '1' AND category='sport' ORDER BY `date` DESC";
$data_news=mysql_query($sql_news, $db);
while ($next_news = mysql_fetch_object ($data_news))
{
$date = date("d.m.y",$next_news->date);
$day = date("H:i",$next_news->date);
$empty_news++;
print "$date - $day Uhr: ";
$next_id=$next_news->id;
$next_name=$next_news->titel;
print "";
secure($next_name);
print "
";
}
if(empty($empty_news))
{
print "Keine Artikel gefunden";
}
/*else {
print "Fussball";
print " Aktuelle Tabelle 1.Klasse A ";
print "Aktueller Spielplan 1.Klasse A ";
print " Alle Artikel";
}*/
?> |