0)
{
$type_query = "select * from event_type where event_type_id = $_GET[type]";
$type_result = mysqli_query($GLOBALS["___mysqli_ston"], $type_query);
$type_count = mysqli_num_rows($type_result);
if ($type_count)
{
$event_type = mysqli_fetch_assoc($type_result);
$heading = $event_type['event_type'];
$where_clause = "AND event.event_type_id = $_GET[type]";
}
else
{
$heading="All Events";
$where_clause = "AND event.start_date != '0000-00-00' ";
}
}
else
{
$heading="All Events";
$where_clause = "AND event.start_date != '0000-00-00' ";
}
$event_query = "
select * from event
join event_status on event.event_status_id = event_status.event_status_id
join person_group on event.person_group_id = person_group.person_group_id
where event_status.event_status_id in (1,2)
$where_clause
order by start_date
";
$event_result = mysqli_query($GLOBALS["___mysqli_ston"], $event_query);
$event_count = mysqli_num_rows($event_result);
echo("
\n");
else
echo("
$heading
\n"); if ($event_count) { ?>| $newname ".stripslashes($event[description])." Registration $event[event_status] | ");
echo("");
echo("Dates: ");
echo(mysql_to_date($event['start_date']));
if ($event['end_date'] != '0000-00-00')
echo("-" . mysql_to_date($event['end_date']));
if ($event['days'])
echo(" ($event[days])");
echo("\n");
if ($event['price_text'])
echo(" Cost: $event[price_text]"); if ($event['reg_date'] != '0000-00-00') { $reg_date = mysql_to_date($event['reg_date']); echo(" Register by $reg_date"); } echo(" Participants: $event[person_group] |
Return to the main events page
There are currently no events schedule of this type. You may browse the main events page to find additional events.\n"); } ?>