Event Schedule

Click a region to start


\n"); $sql="select distinct MONTH(stamp) as mo,YEAR(stamp) as year from tblEvents where eventState='$state' order by mo asc"; $result=db_query($sql); while($row=mysql_fetch_array($result)){ $mo=$row['mo']; $year=$row['year']; $mon=date("F", mktime(0, 0, 0, $mo, 1, $year)); $holder.="".$mon." ".$year."  \n"; } $holder.="
"; $getmo=$_GET['mo']; $getyear=$_GET['year']; $mon=$_GET['mon']; if($getmo && $getyear){ $qry.="&& MONTH(stamp)='$getmo' && YEAR(stamp)='$getyear'"; } $sql2="select eventID, stamp, eventTitle, eventCompany, eventAddress, eventCity, eventState, eventTime, eventType, eventPub, MONTH(stamp) as mo, DAY(stamp) as day, YEAR(stamp) as year from tblEvents where eventPub='Yes' && eventState='$state' $qry order by stamp asc"; $result2=db_query($sql2); #print($sql2); $count2=mysql_num_rows($result2); if($count2<1){ $holder.="Both public and private events in ".$state." will be posted as they become available.


"; }else{ $holder.="\n"; $holder.="\n"; $holder.="
*Shows listed in RED are private   *Shows listed in GREEN are public

\n"; $holder.=""; if($mon && $getyear){ $holder.="\n"; $holder.="\n"; $holder.="\n"; } while($row2=mysql_fetch_array($result2)){ $eventTitle=$row2['eventTitle']; $eventCompany=$row2['eventCompany']; $eventAddress=$row2['eventAddress']; $eventCity=$row2['eventCity']; $eventState=$row2['eventState']; $eventTime=$row2['eventTime']; $stamp=$row2['stamp']; $mo=$row2['mo']; $day=$row2['day']; $year=$row2['year']; $comb=strtotime("".$mo."/".$day."/".$year.""); $dayofweek=strftime("%A",$comb); $eventType=$row2['eventType']; if($eventType=='public'){ $style="body_content_events-public"; }else{ $style="body_content_events-private"; } $eventPub=$row2['eventPub']; $holder.="\n"; $holder.="\n"; $holder.="\n"; $holder.="\n"; $holder.="\n"; $holder.="\n"; } $holder.="
".$mon." ".$getyear."
".$mo.".".$day.".".$year."".$eventTitle.""; if($eventCompany){ $holder.="/".$eventCompany.""; } $holder.="".$eventAddress."
".$eventCity.", ".$eventState."
".$eventTime."



\n"; } print("Upcoming ".$state." Events

"); echo($holder); }?>
About Us Support