//kevhines added fixedtstamp to fix wrong time stamp
//and then removed lots and lots of stuff that is not needed since we are not showing calendar
//and since we don't allow user to select date
$fixedtstamp = time() - 39600;
$month = date("n",$fixedtstamp);
$year = date("Y",$fixedtstamp);
$today = date("j",$fixedtstamp);
$sql_date = "$year-$month-$today";
$eventQuery = "SELECT title, event, html, eventdate FROM cal WHERE eventdate >= '$sql_date' order by eventdate desc;";
$eventExec = mysql_query($eventQuery);
while($row = mysql_fetch_array($eventExec)) {
$html_setting = $row["html"];
$event_title = stripslashes($row["title"]);
$event_title = htmlspecialchars($event_title);
$event_event = stripslashes($row["event"]);
$temp_vari = $row["eventdate"];
$next_month = date("m",strtotime($temp_vari));
$next_D= date("D",strtotime($temp_vari));
$next_day= date("d",strtotime($temp_vari));
$next_mon= date("M",strtotime($temp_vari));
$next_yr= date("Y",strtotime($temp_vari));
if ($html_setting != 1) {
$event_event = htmlspecialchars($event_event);
$event_event = ereg_replace ("\n", " \n", $event_event);
}
}
//begin outer table structure
echo "
|
|
|
";
//kevhines changed to always show upcoming show
//this might break if no EVENT at all found
//echo "$next_D, $next_mon $next_day @$event_title \n";
echo "$event_title \n";
echo "$event_event";
echo " |
|
\n";
?>
|
|