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

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

?>

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

Club/League:   Tryout 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
 
Gender: Boys
Girls
Competition Level:
Academy Select
Premier MRL
 

get_results($qry);

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

if($_POST[clubName])
{
$qry = $qry . “select t.* from wp_mysl_event_sub s join wp_mysl_event_sub_tryouts t on s.id = t.eventSubID where s.myslApproved = 1″ . ” and t.clubName like ‘%”.$_POST[clubName].”%'”;

}

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

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

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

$qry = $qry . “select t.* from wp_mysl_event_sub s join wp_mysl_event_sub_tryouts 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_sub_tryouts t on s.id = t.eventSubID where s.myslApproved = 1"; $qry = $qry . " order by t.tryoutDateTime, t.clubName"; $searchResults = $wpdb->get_results($qry);

echo(“Displaying all available events…”);
}
else
{

$qry = $qry . ” order by tryoutDateTime, clubName”;

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

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

$qry = $qry . ” order by t.tryoutDateTime, t.clubName”;

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

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

?>

Club Tryout Date Age Group(s) Gender(s) Competition Website
clubName); ?> tryoutDateTime); ?> ageGroups); ?> gender); ?> competition); ?>

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