The following listing of meetings is within a +- 30 day range";
// build meetings table
$content = "";
$content .="
|
Date |
Center Name |
";
// grab meetings that are within +- 30 days of today
$range = 30; // in days
$sql = "SELECT id, date, center_name FROM meeting WHERE date = CURRENT_DATE";
$result = mysql_query($sql);
// display today's meetings
while (list($id, $date, $cname) = mysql_fetch_array($result))
{
$content .= "
![\"square\"](\"images/square.gif\") |
" . d_num_to_word($date) . " |
" . $cname . " |
";
}
$content .= '
|
';
$range = 30; // in days
$sql = "SELECT id, date, center_name FROM meeting WHERE date BETWEEN NOW() - INTERVAL " . $range . " DAY AND NOW() + INTERVAL " . $range . " DAY ORDER BY date ASC";
$result = mysql_query($sql);
// display active meetings
while (list($id, $date, $cname) = mysql_fetch_array($result))
{
$content .= "
|
" . d_num_to_word($date) . " |
" . $cname . " |
";
}
// finish table
$content .= "
";
?>
On March 1, 2012 the LIFE form website will move to www.iucrc.com. All of the previous meeting data has been transferred.
