Himmelsereignisse
='$datum_heute' order by datum ASC LIMIT 20" ;
$resulth = mysqli_query($db,$sql_selh) OR die(mysqli_error($db));
if(mysqli_num_rows($resulth))
{
echo "
";
while($rowh = mysqli_fetch_assoc($resulth))
{ if ($rowh['min']!="") {$min="m";}
else{$min="";}
$datum = $rowh['datum'];
$datumf=preg_replace('#^(\d{4})(\d{2})(\d{2})$#', '\3.\2.\1', $datum);
// if(preg_match("([0-9]{4})([0-9]{1,2})([0-9]{1,2})", $rowh['datum'],$resh))
// { $datumf="$resh[3].$resh[2].$resh[1]"; }
echo "| ".$datumf." | ".$rowh['uhrzeit']."h ".$rowh['min'];
echo $min." (MEZ) | ".$rowh['beschreibung']." |
";
}
echo "
";}
else {echo "Keine Himmelsereignisse in der Datenbank gefunden";}
?>
Himmelsereignisse der vergangenen Wochen