
 |
 |
 |
/*
$query = "select date_format(Start_day, '%M') from calendar where '$year' = date_format(Start_day, '%Y') order by Start_day";
$result = mysql_query($query);
$num_results = mysql_num_rows($result);
$row = mysql_fetch_array($result);
$y = 0;
// month display
for ($i=0; $i < $num_results; $i++)
{
if ($month == $row["date_format(Start_day, '%M')"])
{
$row = mysql_fetch_array($result);
}
else
{
if ($y != 0)
{
echo " | ";
}
$month = $row["date_format(Start_day, '%M')"];
//echo $year." \n";
echo "".$month."";
$row = mysql_fetch_array($result);
$y++;
}
}
*/?>
/*
$query1 = "select date_format(Start_day, '%M'),
date_format(Start_day, '%e'),
date_format(Start_day, '%W'),
date_format(End_day, '%M'),
date_format(End_day, '%e'),
date_format(End_day, '%W'),
time_format(Start_time, '%l'),
time_format(Start_time, '%i'),
time_format(Start_time, '%p'),
time_format(End_time, '%l'),
time_format(End_time, '%i'),
time_format(End_time, '%p'),
event_name, text, location
from calendar where '$year' = date_format(Start_day, '%Y')
order by Start_day, Start_time";
$result1 = mysql_query($query1);
$num_results1 = mysql_num_rows($result1);
echo "";
for ($j=0; $j < $num_results1; $j++)
{
$row1 = mysql_fetch_array($result1);
$start_month = $row1["date_format(Start_day, '%M')"];
$start_day = $row1["date_format(Start_day, '%e')"];
$start_day_w = $row1["date_format(Start_day, '%W')"];
$end_month = $row1["date_format(End_day, '%M')"];
$end_day = $row1["date_format(End_day, '%e')"];
$end_day_w = $row1["date_format(End_day, '%W')"];
$start_time_hour = $row1["time_format(Start_time, '%l')"];
$start_time_min = $row1["time_format(Start_time, '%i')"];
$start_time_ampm = $row1["time_format(Start_time, '%p')"];
$end_time_hour = $row1["time_format(End_time, '%l')"];
$end_time_min = $row1["time_format(End_time, '%i')"];
$end_time_ampm = $row1["time_format(End_time, '%p')"];
$event_name = stripslashes($row1["event_name"]);
$text = nl2br(stripslashes($row1["text"]));
$location = $row1["location"];
// month and year
if ($month2 != $start_month)
{
$month2 = $start_month;
echo "| ";
echo "".$month2." ".$year."";
echo " | ";
}
echo "\n";
// fix AM and PM to am and pm
if ($start_time_ampm == 'AM')
{
$start_time_ampm = 'am';
}
else
{
$start_time_ampm = 'pm';
}
if ($end_time_ampm == 'AM')
{
$end_time_ampm = 'am';
}
else
{
$end_time_ampm = 'pm';
}
// date and time
echo "| \n";
echo "".$start_day;
if ($end_month == "")
{
if (($start_time_hour == 12) && ($start_time_ampm == 'am'))
{
echo $start_day_w." | \n";
//echo " \n";
}
else if (($end_time_hour == 12) && ($end_time_ampm == 'am'))
{
echo " ".$start_day_w." ".$start_time_hour.":".$start_time_min.$start_time_ampm;
echo "\n";
//echo "\n";
}
else if ($start_time_ampm == $end_time_ampm)
{
echo " ".$start_day_w." ".$start_time_hour.":".$start_time_min." - ".$end_time_hour.":".$end_time_min.$end_time_ampm;
echo "\n";
//echo "\n";
}
else
{
echo " ".$start_day_w." ".$start_time_hour.":".$start_time_min.$start_time_ampm." - ".$end_time_hour.":".$end_time_min.$end_time_ampm;
echo "\n";
//echo "\n";
}
}
else if ($start_month == $end_month)
{
if (($start_time_hour == 12) && ($start_time_ampm == 'am'))
{
echo " - ".$end_day." ";
echo $start_day_w." - ".$end_day_w."\n";
//echo "\n";
}
else if (($end_time_hour == 12) && ($end_time_ampm == 'am'))
{
echo " - ".$end_day." ".$start_day_w." - ".$end_day_w." ".$start_time_hour.":".$start_time_min.$start_time_ampm;
echo "\n";
//echo "\n";
}
else if ($start_time_ampm == $end_time_ampm)
{
echo " - ".$end_day." ".$start_day_w." - ".$end_day_w." ".$start_time_hour.":".$start_time_min." - ".$end_time_hour.":".$end_time_min.$end_time_ampm;
echo "\n";
//echo "\n";
}
else
{
echo " - ".$end_day." ".$start_day_w." - ".$end_day_w." ".$start_time_hour.":".$start_time_min.$start_time_ampm." - ".$end_time_hour.":".$end_time_min.$end_time_ampm;
echo "\n";
//echo "\n";
}
}
else
{
if (($start_time_hour == 12) && ($start_time_ampm == 'am'))
{
echo " - ".$end_day;
echo $start_day_w." - ".$end_day_w."\n";
//echo "\n";
}
else if (($end_time_hour == 12) && ($end_time_ampm == 'am'))
{
echo " - ".$end_day." ".$start_day_w." - ".$end_day_w." ".$start_time_hour.":".$start_time_min.$start_time_ampm;
echo "\n";
//echo "\n";
}
else if ($start_time_ampm == $end_time_ampm)
{
echo " - ".$end_day." ".$start_day_w." - ".$end_day_w." ".$start_time_hour.":".$start_time_min." - ".$end_time_hour.":".$end_time_min.$end_time_ampm;
echo "\n";
//echo "\n";
}
else
{
echo " - ".$end_day." ".$start_day_w." - ".$end_day_w." ".$start_time_hour.":".$start_time_min.$start_time_ampm." - ".$end_time_hour.":".$end_time_min.$end_time_ampm;
echo "\n";
//echo "\n";
}
}
//echo "\n";
echo "";
// event name
echo "".$event_name." ";
// info
echo $text."
";
echo "Location: ".$location."
";
echo " | ";
echo " \n";
}
echo " ";
*/ ?>
|
If you would like to be notified by email of our
future performances, please fill out the form below.
Mailing List Registration
We will not give or sell your name or email address to anyone for any reason. |
|
|
 |