Committee meetings are subject to change
Schedules are based on committee member availability and completion of staff workload.
Please call Nancy Hatfield at (925) 828-0515 to confirm dates, times and locations.
';
$sql = "select id, title, bgcolor from meetingscategories where id<>3 and id<>4 and id<>16 and id<>17 and id<>18 order by title";
$db = mysql_connect('localhost', 'dsrsdc', '53Dstrct');
mysql_select_db("dsrsdc",$db);
$result = mysql_query($sql);
//echo "Title: " . $result .':'. mysql_errno() . ": " . mysql_error(). " \n";
while ($myrow = mysql_fetch_array($result)) {
print displayminutes($myrow["id"], $myrow["title"], $myrow["bgcolor"]);
}
}
function displayminutes($id, $title, $bgcolor){
//$sql = "select canceled, special, meetingdate, rescheduled, agenda, location from meetings where (category=3 or category=4) and meetingdate>=DATE_SUB(CURDATE(),INTERVAL 365 DAY) order by meetingdate DESC";
$sqlParam1 = "(select special, canceled, meetingdate, reschedule, 'false' as isrescheduled, agenda, location from meetings where meetingdate>=DATE_SUB(CURDATE(),INTERVAL 3 MONTH) and category=".$id." and reschedule='0000-00-00')";
$sqlParam2 = " UNION ";
$sqlParam3 = "(select special, canceled, reschedule as meetingdate, meetingdate as reschedule, 'true' as isrescheduled, agenda, location from meetings where reschedule>=DATE_SUB(CURDATE(),INTERVAL 3 MONTH) and category=".$id.")";
$sqlParam4 = " order by meetingdate desc";
$sql = $sqlParam1.$sqlParam2.$sqlParam3.$sqlParam4;
$db = mysql_connect('localhost', 'dsrsdc', '53Dstrct');
mysql_select_db("dsrsdc",$db);
$result = mysql_query($sql);
$number = mysql_numrows($result);
//echo "mysql_errno: " . mysql_errno() ." ";
//echo "mysql_error: " . mysql_error() ." ";
//echo "number: " . $number ." ";
//echo "title: " . $title ." ";
//echo "id: " . $id ."
