| |
|
|
** To submit a new event, Click HERE
|
January 2010
|
|
Sun
|
Mon
|
Tues
|
Wed
|
Thurs
|
Fri
|
Sat
|
";
for ($day=0;$day<=6;$day++){
$currentDay=strtotime("$date +$counter days");
$dayFormat=date("M j",$currentDay);
$SQLdate=date("Y-m-j",$currentDay);
$query_rs_events = "SELECT event, id FROM OHE_MLK_calendar WHERE `date`='$SQLdate' AND approved=1";
$rs_events = mysql_query($query_rs_events, $pgc) or die(mysql_error());
$row_rs_events = mysql_fetch_assoc($rs_events);
$totalRows_rs_events = mysql_num_rows($rs_events);
echo "$dayFormat ";
do {
if ($totalRows_rs_events) {echo "{$row_rs_events['event']}
";}
} while ($row_rs_events = mysql_fetch_assoc($rs_events));
echo " | ";
$counter++;
}
echo "";
}
echo " ";
$sqlDate=$SQLdate=date("Y-m-j",strtotime($date));
$query_rs_full = "SELECT *
FROM OHE_MLK_calendar
WHERE `date`>'$sqlDate' AND approved=1
ORDER BY OHE_MLK_calendar.`date`";
$rs_full = mysql_query($query_rs_full, $pgc) or die(mysql_error());
$row_rs_full = mysql_fetch_assoc($rs_full);
$totalRows_rs_full = mysql_num_rows($rs_full);
if ($totalRows_rs_full) {
echo "
";
do {
if ($currentDate!=$row_rs_full['date']) {
$formatDate=date("D, F j",strtotime($row_rs_full['date']));
echo "| $formatDate | ";
$currentDate=$row_rs_full['date'];
}
echo " | ";
echo "{$row_rs_full['event']}
";
echo "{$row_rs_full['time']}
";
echo "{$row_rs_full['location']}
";
echo "ACCESS: {$row_rs_full['access']}
";
echo "
{$row_rs_full['description']}
";
echo "Sponsored by: {$row_rs_full['org']}
";
echo "Contact: {$row_rs_full['contact']} {$row_rs_full['phone']}
";
echo "
| ";
} while ($row_rs_full = mysql_fetch_assoc($rs_full));
echo " | ";
}
?>
|
