<?
$pre   = '';
include "common.php";
$title = 'Meeting Calendar';
// Since register_globals is on, the $_GET variables override anything
// I set in my scripts so I have this $imenu for initial menu then it
// can be reset by the $_GET['menu'] variable.
$imenu = 'calendar';
$logo  = true;
include HEAD;

//$tbname  = TABLE_EVENTS;
$primary = 'id';
$today   = date('Ymd');
$recent  = date('Ymd',strtotime("-90 days"));

switch ($when){
case 'past':
   $query  = "SELECT * FROM " . TABLE_CALENDAR . " WHERE end>=" . $recent . " AND end<" . $today . " ORDER BY end DESC";
   $header = "Meetings Concluded in the Last 90 Days";
   break;
case 'old':
   $query  = "SELECT * FROM " . TABLE_CALENDAR . " WHERE end<" . $recent . " ORDER BY end DESC";
   $header = "Meetings Older Than 90 Days";
   break;
default:
   $query  = "SELECT * FROM " . TABLE_CALENDAR . " WHERE end>=" . $today . " ORDER BY start";
   $header = "Upcoming Meetings of Interest";
   break;
}
$events = $db->sql_query($query);
?>
<form name="when" method="get" action="">
<select name="when" onChange="whenChange(this.options[this.selectedIndex].value);">
   <option value="" <?if($when == "")echo "selected";?>>Upcoming Meetings</option>
   <option value="past" <?if($when == "past")echo "selected";?>>Recently Concluded Meetings</option>
   <option value="old" <?if($when == "old")echo "selected";?>>Old Meetings</option>
</select>
</form>
<br />
<table style="width: 100%" border="1">
<tr>
   <td align="center">
      <h2><?=$header?></h2>
   </td>
</tr>
<tr>
   <td>
<?
      while($row = $db->sql_fetchrow($events)){
         echo "      <table>\n";
         echo display_event($row,'      ');
         echo "      </table>\n   <td>\n</tr>\n<tr>\n   <td>\n";
      }
?>

   </td>
</tr>
</table>
<?
include FOOT;
?>
