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("

$heading

\n"); if ($event_count) { ?> \n"); else echo("\n"); $newname = stripslashes($event['name']); echo(""); echo("\n"); } ?>
$newname
".stripslashes($event[description])."
Registration $event[event_status]
"); 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"); } ?>