|
=$today order by eventdate ASC";
$total_result = @mysql_query($sql, $connection) or die("Error #". mysql_errno() . ": " . mysql_error());
$total_found = @mysql_num_rows($total_result);
while ($row = mysql_fetch_array($total_result)) {
$eventdate=$row['eventdate'];
/* formats date and sets to new variable while keeping timestamp for ordering */
$eventdatef=$row['eventdatef'];
$eventime=$row['eventime'];
$event=$row['event'];
$notes=$row['notes'];
/* adds br tag where there is a line break */
$notes = ereg_replace("(\r\n|\n|\r)", "
",$notes);
$display_block .= " |
| $eventdatef | $eventime | $event | $notes |
";
}
if ($total_found != 0) {
include("event_list.html");
} else {
include("event_list_none.html");
}
?>
