prepare(“select distinct clubID, clubName from wp_mysl_clubs order by clubName”);

$clubs = $wpdb->get_results($qry);

?>

Use this form to search for upcoming Open House events. You can specify any criteria you’d wish to search for. If you wish to see all available Open House events, do not enter any criteria, and simply click the search button.

Club/League:   Open House Date: >
Age Group(s):
Any U-08 U-09 U-10
U-11 U-12 U-13 U-14
U-15 U-16 U-17 U-18
U-19
   
 

get_results($qry);

if(!$searchResults)
{
$qry = “”;

if($_POST[clubLeagueName])
{
$qry = $qry . “select t.* from wp_mysl_event_sub s join wp_mysl_event_submissions t on s.id = t.eventSubID where s.myslApproved = 1″ . ” and t.clubLeagueName = ‘”.$_POST[clubLeagueName].”‘”;
}

if($_POST[openHouseDate])
{
if (strlen($qry) > 0)
{
$qry = $qry . ” union “;
}

$qry = $qry . “select t.* from wp_mysl_event_sub s join wp_mysl_event_submissions t on s.id = t.eventSubID where s.myslApproved = 1″ . ” and t.eventDatesAndTimes like ‘%”.$_POST[openHouseDate].”%'”;
}

if($_POST[AgeGroups])
{
if (strlen($qry) > 0)
{
$qry = $qry . ” union “;
}

$qry = $qry . “select t.* from wp_mysl_event_sub s join wp_mysl_event_submissions t on s.id = t.eventSubID where s.myslApproved = 1″ . ” and ( t.AgeGroups like ‘%”;

foreach($_POST[AgeGroups] as $ages)
{
if($ages==”Any”)
{
$qry = $qry . “%’ or t.AgeGroups like ‘%”;
}
else
{
$qry = $qry . $ages. “%’ or t.AgeGroups like ‘%”;
}
}

$qry = substr($qry,0,strlen($qry)-22).”)”;
}

if(strlen($qry) < 1) { $qry = "select t.* from wp_mysl_event_sub s join wp_mysl_event_submissions t on s.id = t.eventSubID where s.myslApproved = 1"; $qry = $qry . " order by t.eventDatesAndTimes, t.clubLeagueName"; $searchResults = $wpdb->get_results($qry);

echo(“Displaying all available events…”);
}
else
{
$qry = $qry . ” order by eventDatesAndTimes, clubLeagueName”;

$searchResults = $wpdb->get_results($qry);

if(!$searchResults)
{
$qry = “select t.* from wp_mysl_event_sub s join wp_mysl_event_submissions t on s.id = t.eventSubID where s.myslApproved = 1″;

$qry = $qry . ” order by t.eventDatesAndTimes, t.clubLeagueName”;

$searchResults = $wpdb->get_results($qry);

echo(“We’re sorry, there are no open houses that match your exact search criteria. There were also no partial matches. Below is a list of all open houses on file.”);
}
else
{
echo(“We’re sorry, there are no open houses that match your exact search criteria. We’ve searched for partial matches, and listed them below.”);
}
}
}

?>

Club Date(s) and Time(s) Age Group(s) & Gender(s) Event Contact Event Details
clubLeagueName); ?> eventDatesAndTimes); ?> AgeGroups); ?>
Genders); ?>
eventInfoContactName); ?>
Details: eventDetails); ?>
Location: eventLocation); ?>

january

tue23jan7:00 pm- 9:00 pmSpring 2018 Registration Clubs/Leagues A-M7:00 pm - 9:00 pm

wed24jan7:00 pm- 9:00 pmSpring 2018 Registration Clubs/Leagues N-Z7:00 pm - 9:00 pm

february

tue13feb7:00 pm- 9:00 pmSpring 2018 Divisioning-All Teams7:00 pm - 9:00 pm

X