o.k., here comes the whole story:
<?php
$events = mysql_query($select . $from . $where . $how);
if (!$events) {
echo("</table>");
echo("<p>Fehler bei der Suche nach der Nachricht in der Datenbank!<br />".
"Fehler: " . mysql_error() . "</p>");
exit();
}
// permit breaks and paragraphs
$address = ereg_replace("\r","",$address);
$address = ereg_replace("\n\n","<p></p>",$address);
$address = ereg_replace("\n","<br />",$address);
$day_time = ereg_replace("\r","",$day_time);
$day_time = ereg_replace("\n\n","<p></p>",$day_time);
$day_time = ereg_replace("\n","<br />",$day_time);
//print code to start the news table
print("<table width=\"560\"border=\"0\"bgcolor=\"#ffffff\"cellpadding=\"1\"cellspacing=\"2\">");
while ($event = mysql_fetch_array($events)) {
echo("<tr valign='top'>\n");
$id = $event["id"];
$city = htmlspecialchars($event["city"]);
$address = htmlspecialchars($event["address"]);
$day_time = htmlspecialchars($event["day_time"]);
$conntact = htmlspecialchars($event["conntact"]);
$URL = htmlspecialchars($event["URL"]);
// start table with results
print("<tr bgcolor='eeeeee' valign='top' halign='left'><td><font class='news-headline-2'>$city</font></td><td> </td><td> </td></tr>\n");
print("<tr valign='top' halign='left'><td class='news-content'>$address</td><td class='news-content'>$day_time<br><a href=\"http://$URL\" target=\"_blank\">$URL</a></td><td class='news-content'>$conntact</td></tr>\n");
print("<tr valign='top' halign='left'><td> </td><td> </td<td> </td</tr>\n");
}
exit();
// closing table
print("</table>");
?>
