Posting HTML form

Hi,

I have created the following form which is used to query a recipe database and return matching results. The result pages works fine (please see below) and matching recipes are displayed. However, if none of the check boxes are checked when the users submits the form the results page continuously tries to load, but never does. I've tried commenting out all of the content of the results page, but the same thing happens.

Any help would be greatly appreciated.

Thanks!

/**** FORM ****/

<form role = "form" method = "post" action = "search-results.php">
<div class = "form-group">
<h4>Quick search</h4>
<input type = "text" class = "form-control" id = "keyword_search" placeholder = "Enter keywords">
</div>
<h4>Meal</h4>
<div class="form-group">
<div class="checkbox">
<label><input type = "checkbox" id = "breakfast" name = "breakfast" <?php if($breakfast == 'Y'){echo 'checked';} ?>> Breakfast &nbsp;</label>
</div>
<div class="checkbox">
<label><input type = "checkbox" id = "lunch" name = "lunch" <?php if($lunch == 'Y'){echo 'checked';} ?>> Lunch &nbsp;</label>
</div>
<div class="checkbox">
<label><input type = "checkbox" id = "starter" name = "starter" <?php if($starter == 'Y'){echo 'checked';} ?>> Starter &nbsp;</label>
</div>
<div class="checkbox">
<label><input type = "checkbox" id = "dinner" name = "dinner" <?php if($dinner == 'Y'){echo 'checked';} ?>> Dinner &nbsp;</label>
</div>
<div class="checkbox">
<label><input type = "checkbox" id = "dessert" name = "dessert" <?php if($dessert == 'Y'){echo 'checked';} ?>> Dessert &nbsp;</label>
</div>
<div class="checkbox">
<label><input type = "checkbox" id = "snack" name = "snack" <?php if($snack == 'Y'){echo 'checked';} ?>> Snack &nbsp;</label>
</div>
<div class="checkbox">
<label><input type = "checkbox" id = "drink" name = "drink" <?php if($drink == 'Y'){echo 'checked';} ?>> Drink &nbsp;</label>
</div>
</div>
<h4>Suitable for</h4>
<div class="form-group">
<div class="checkbox">
<label><input type = "checkbox" id = "diabetic" name = "diabetic" <?php if($diabetic == 'Y'){echo 'checked';} ?>> Diabetic diet &nbsp;</label>
</div>
<div class="checkbox">
<label><input type = "checkbox" id = "egg_free" name = "egg_free" <?php if($egg_free == 'Y'){echo 'checked';} ?>> Egg free diet &nbsp;</label>
</div>
<div class="checkbox">
<label><input type = "checkbox" id = "gluten_free" name = "gluten_free" <?php if($gluten_free == 'Y'){echo 'checked';} ?>> Gluten free diet &nbsp;</label>
</div>
<div class="checkbox">
<label><input type = "checkbox" id = "high_fibre" name = "high_fibre" <?php if($high_fibre == 'Y'){echo 'checked';} ?>> High fibre diet &nbsp;</label>
</div>
<div class="checkbox">
<label><input type = "checkbox" id = "low_calorie" name = "low_calorie" <?php if($low_calorie == 'Y'){echo 'checked';} ?>> Low calorie diet &nbsp;</label>
</div>
<div class="checkbox">
<label><input type = "checkbox" id = "low_gi" name = "low_gi" <?php if($low_gi == 'Y'){echo 'checked';} ?>> Low GI diet &nbsp;</label>
</div>
<div class="checkbox">
<label><input type = "checkbox" id = "nut_free" name = "nut_free" <?php if($nut_free == 'Y'){echo 'checked';} ?>> Nut free diet &nbsp;</label>
</div>
<div class="checkbox">
<label><input type = "checkbox" id = "pregnancy" name = "pregnancy" <?php if($pregnancy == 'Y'){echo 'checked';} ?>> Pregnancy friendly diet &nbsp;</label>
</div>
<div class="checkbox">
<label><input type = "checkbox" id = "vegan" name = "vegan" <?php if($vegan == 'Y'){echo 'checked';} ?>> Vegan diet &nbsp;</label>
</div>
<div class="checkbox">
<label><input type = "checkbox" id = "vegetarian" name = "vegetarian" <?php if($vegetarian == 'Y'){echo 'checked';} ?>> Vegetarian diet &nbsp;</label>
</div>
</div>
<h4>Time</h4>
<div class="form-group">
<div class="checkbox">
<label><input type = "checkbox" id = "under" name = "under" <?php if($under == 'Y'){echo 'checked';} ?>> Under 20 minutes &nbsp;</label>
</div>
<div class="checkbox">
<label><input type = "checkbox" id = "between" name = "between" <?php if($between == 'Y'){echo 'checked';} ?>> 20 to 45 minutes &nbsp;</label>
</div>
<div class="checkbox">
<label><input type = "checkbox" id = "over" name = "over" <?php if($over == 'Y'){echo 'checked';} ?>> Over 45 minutes &nbsp;</label>
</div>
</div>
<h4>Skill level</h4>
<div class="form-group">
<div class="checkbox">
<label><input type = "checkbox" id = "beginner" name = "beginner" <?php if($beginner == 'Y'){echo 'checked';} ?>> Beginner &nbsp;</label>
</div>
<div class="checkbox">
<label><input type = "checkbox" id = "improver" name = "improver" <?php if($improver == 'Y'){echo 'checked';} ?>> Improver &nbsp;</label>
</div>
<div class="checkbox">
<label><input type = "checkbox" id = "advanced" name = "advanced" <?php if($advanced == 'Y'){echo 'checked';} ?>> Advanced &nbsp;</label>
</div>
</div>
<div class="form-group">
<button type="submit" class="btn btn-md btn-default">Search</button>
</div>
</form>

/**** RESULTS PAGE ****/

<?php
// INCLUDE THE CONFIG FILE TO GET THE BASE_URL VARIABLE
include("includes/config.php");
// INCLUDE THE SQL SETTINGS
include("includes/mysql-connect.php");
// INCLUDE THE HEADER FILE
include("includes/header.php");
// INITIATE SELECT STATEMENT
$sql_search_statement = "SELECT * FROM recipesKM";
/************************/
/************************/
/***** MEAL OPTIONS *****/
/************************/
/************************/
// INITIALISE MEAL CLAUSE COUNT
$meal_clause_count = 0;
// GET BREAKFAST SEARCH CRITERIA
$breakfast = trim($_POST['breakfast'],"'");
// IF IT HAS BEEN CHECKED...
if($breakfast == 'on')
{
// SET IT TO 'Y' SO IT REMAINS CHECKED IN THE FORM
$breakfast = 'Y';
// DETERMINE IF THIS IS FIRST CLAUSE...
if($meal_clause_count == 0)
{
// ADD TO SELECT STATEMENT
$sql_search_statement = $sql_search_statement . " WHERE (course = 'B'";
// INCREMENT THE MEAL CLAUSE COUNT VARIABLE
$meal_clause_count = $meal_clause_count + 1;
}
else
{
// ADD TO SELECT STATEMENT
$sql_search_statement = $sql_search_statement . " OR course = 'B'";
// INCREMENT THE MEAL CLAUSE COUNT VARIABLE
$meal_clause_count = $meal_clause_count + 1;
}
}
// ELSE IT HAS NOT BEEN CHECKED
else
{
$breakfast = 'N';
}
// GET LUNCH SEARCH CRITERIA
$lunch = trim($_POST['lunch'],"'");
// IF IT HAS BEEN CHECKED...
if($lunch == 'on')
{
// SET IT TO 'Y' SO IT REMAINS CHECKED IN THE FORM
$lunch = 'Y';
// DETERMINE IF THIS IS FIRST CLAUSE...
if($meal_clause_count == 0)
{
// ADD TO SELECT STATEMENT
$sql_search_statement = $sql_search_statement . " WHERE (course = 'L'";
// INCREMENT THE MEAL CLAUSE COUNT VARIABLE
$meal_clause_count = $meal_clause_count + 1;
}
else
{
// ADD TO SELECT STATEMENT
$sql_search_statement = $sql_search_statement . " OR course = 'L'";
// INCREMENT THE MEAL CLAUSE COUNT VARIABLE
$meal_clause_count = $meal_clause_count + 1;
}
}
// ELSE IT HAS NOT BEEN CHECKED
else
{
$lunch = 'N';
}
// GET STARTER SEARCH CRITERIA
$starter = trim($_POST['starter'],"'");
// IF IT HAS BEEN CHECKED...
if($starter == 'on')
{
// SET IT TO 'Y' SO IT REMAINS CHECKED IN THE FORM
$starter = 'Y';
// DETERMINE IF THIS IS FIRST CLAUSE...
if($meal_clause_count == 0)
{
// ADD TO SELECT STATEMENT
$sql_search_statement = $sql_search_statement . " WHERE (course = 'St'";
// INCREMENT THE MEAL CLAUSE COUNT VARIABLE
$meal_clause_count = $meal_clause_count + 1;
}
else
{
// ADD TO SELECT STATEMENT
$sql_search_statement = $sql_search_statement . " OR course = 'St'";
// INCREMENT THE MEAL CLAUSE COUNT VARIABLE
$meal_clause_count = $meal_clause_count + 1;
}
}
// ELSE IT HAS NOT BEEN CHECKED
else
{
$starter = 'N';
}
// GET DINNER SEARCH CRITERIA
$dinner = trim($_POST['dinner'],"'");
// IF IT HAS BEEN CHECKED...
if($dinner == 'on')
{
// SET IT TO 'Y' SO IT REMAINS CHECKED IN THE FORM
$dinner = 'Y';
// DETERMINE IF THIS IS FIRST CLAUSE...
if($meal_clause_count == 0)
{
// ADD TO SELECT STATEMENT
$sql_search_statement = $sql_search_statement . " WHERE (course = 'D'";
// INCREMENT THE MEAL CLAUSE COUNT VARIABLE
$meal_clause_count = $meal_clause_count + 1;
}
else
{
// ADD TO SELECT STATEMENT
$sql_search_statement = $sql_search_statement . " OR course = 'D'";
// INCREMENT THE MEAL CLAUSE COUNT VARIABLE
$meal_clause_count = $meal_clause_count + 1;
}
}
// ELSE IT HAS NOT BEEN CHECKED
else
{
$dinner = 'N';
}
// GET DESSERT SEARCH CRITERIA
$dessert = trim($_POST['dessert'],"'");
// IF IT HAS BEEN CHECKED...
if($dessert == 'on')
{
// SET IT TO 'Y' SO IT REMAINS CHECKED IN THE FORM
$dessert = 'Y';
// DETERMINE IF THIS IS FIRST CLAUSE...
if($meal_clause_count == 0)
{
// ADD TO SELECT STATEMENT
$sql_search_statement = $sql_search_statement . " WHERE (course = 'De'";
// INCREMENT THE MEAL CLAUSE COUNT VARIABLE
$meal_clause_count = $meal_clause_count + 1;
}
else
{
// ADD TO SELECT STATEMENT
$sql_search_statement = $sql_search_statement . " OR course = 'De'";
// INCREMENT THE MEAL CLAUSE COUNT VARIABLE
$meal_clause_count = $meal_clause_count + 1;
}
}
// ELSE IT HAS NOT BEEN CHECKED
else
{
$dessert = 'N';
}
// GET SNACK SEARCH CRITERIA
$snack = trim($_POST['snack'],"'");
// IF IT HAS BEEN CHECKED...
if($snack == 'on')
{
// SET IT TO 'Y' SO IT REMAINS CHECKED IN THE FORM
$snack = 'Y';
// DETERMINE IF THIS IS FIRST CLAUSE...
if($meal_clause_count == 0)
{
// ADD TO SELECT STATEMENT
$sql_search_statement = $sql_search_statement . " WHERE (course = 'S'";
// INCREMENT THE MEAL CLAUSE COUNT VARIABLE
$meal_clause_count = $meal_clause_count + 1;
}
else
{
// ADD TO SELECT STATEMENT
$sql_search_statement = $sql_search_statement . " OR course = 'S'";
// INCREMENT THE MEAL CLAUSE COUNT VARIABLE
$meal_clause_count = $meal_clause_count + 1;
}
}
// ELSE IT HAS NOT BEEN CHECKED
else
{
$snack = 'N';
}
// GET DRINK SEARCH CRITERIA
$drink = trim($_POST['drink'],"'");
// IF IT HAS BEEN CHECKED...
if($drink == 'on')
{
// SET IT TO 'Y' SO IT REMAINS CHECKED IN THE FORM
$drink = 'Y';
// DETERMINE IF THIS IS FIRST CLAUSE...
if($meal_clause_count == 0)
{
// ADD TO SELECT STATEMENT
$sql_search_statement = $sql_search_statement . " WHERE (course = 'Dr'";
// INCREMENT THE MEAL CLAUSE COUNT VARIABLE
$meal_clause_count = $meal_clause_count + 1;
}
else
{
// ADD TO SELECT STATEMENT
$sql_search_statement = $sql_search_statement . " OR course = 'Dr'";
// INCREMENT THE MEAL CLAUSE COUNT VARIABLE
$meal_clause_count = $meal_clause_count + 1;
}
}
// ELSE IT HAS NOT BEEN CHECKED
else
{
$drink = 'N';
}
// IF AT LEAST ONE OF THE MEAL OPTIONS HAS BEEN SELECTED...
if($meal_clause_count != 0)
{
// CONCATENATE A CLOSING BRACE ONTO THE END OF THE SELECT STATEMENT
$sql_search_statement = $sql_search_statement . ")";
}
/********************************/
/********************************/
/***** SUITABLE FOR OPTIONS *****/
/********************************/
/********************************/
// INITIATE THE SUITABLE FOR CLAUSE COUNT
$suitable_for_clause_count = 0;
// GET VEGAN SEARCH CRITERIA
$vegan = trim($_POST['vegan'],"'");
// IF IT HAS BEEN CHECKED...
if($vegan == 'on')
{
// SET IT TO 'Y' SO IT REMAINS CHECKED IN THE FORM
$vegan = 'Y';
// DETERMINE IF THIS IS FIRST CLAUSE...
if($suitable_for_clause_count == 0 && $meal_clause_count == 0)
{
// ADD TO SELECT STATEMENT
$sql_search_statement = $sql_search_statement . " WHERE suitable_for_vegan = 'Y'";
// INCREMENT THE SUITABLE FOR CLAUSE COUNT VARIABLE
$suitable_for_clause_count = $suitable_for_clause_count + 1;
}
else
{
// ADD TO SELECT STATEMENT
$sql_search_statement = $sql_search_statement . " AND suitable_for_vegan = 'Y'";
// INCREMENT THE SUITABLE FOR CLAUSE COUNT VARIABLE
$suitable_for_clause_count = $suitable_for_clause_count + 1;
}
}
// ELSE IT HAS NOT BEEN CHECKED
else
{
$vegan = 'N';
}
// GET VEGETARIAN SEARCH CRITERIA
$vegetarian = trim($_POST['vegetarian'],"'");
// IF IT HAS BEEN CHECKED...
if($vegetarian == 'on')
{
// SET IT TO 'Y' SO IT REMAINS CHECKED IN THE FORM
$vegetarian = 'Y';
// DETERMINE IF THIS IS FIRST CLAUSE...
if($suitable_for_clause_count == 0 && $meal_clause_count == 0)
{
// ADD TO SELECT STATEMENT
$sql_search_statement = $sql_search_statement . " WHERE suitable_for_vegetarian = 'Y'";
// INCREMENT THE SUITABLE FOR CLAUSE COUNT VARIABLE
$suitable_for_clause_count = $suitable_for_clause_count + 1;
}
else
{
// ADD TO SELECT STATEMENT
$sql_search_statement = $sql_search_statement . " AND suitable_for_vegetarian = 'Y'";
// INCREMENT THE SUITABLE FOR CLAUSE COUNT VARIABLE
$suitable_for_clause_count = $suitable_for_clause_count + 1;
}
}
// ELSE IT HAS NOT BEEN CHECKED
else
{
$vegetarian = 'N';
}
// GET DIABETIC SEARCH CRITERIA
$diabetic = trim($_POST['diabetic'],"'");
// IF IT HAS BEEN CHECKED...
if($diabetic == 'on')
{
// SET IT TO 'Y' SO IT REMAINS CHECKED IN THE FORM
$diabetic = 'Y';
// DETERMINE IF THIS IS FIRST CLAUSE...
if($suitable_for_clause_count == 0 && $meal_clause_count == 0)
{
// ADD TO SELECT STATEMENT
$sql_search_statement = $sql_search_statement . " WHERE suitable_for_diabetic = 'Y'";
// INCREMENT THE SUITABLE FOR CLAUSE COUNT VARIABLE
$suitable_for_clause_count = $suitable_for_clause_count + 1;
}
else
{
// ADD TO SELECT STATEMENT
$sql_search_statement = $sql_search_statement . " AND suitable_for_diabetic = 'Y'";
// INCREMENT THE SUITABLE FOR CLAUSE COUNT VARIABLE
$suitable_for_clause_count = $suitable_for_clause_count + 1;
}
}
// ELSE IT HAS NOT BEEN CHECKED
else
{
$diabetic = 'N';
}
// GET GLUTEN FREE SEARCH CRITERIA
$gluten_free = trim($_POST['gluten_free'],"'");
// IF IT HAS BEEN CHECKED...
if($gluten_free == 'on')
{
// SET IT TO 'Y' SO IT REMAINS CHECKED IN THE FORM
$gluten_free = 'Y';
// DETERMINE IF THIS IS FIRST CLAUSE...
if($suitable_for_clause_count == 0 && $meal_clause_count == 0)
{
// ADD TO SELECT STATEMENT
$sql_search_statement = $sql_search_statement . " WHERE suitable_for_gluten_free = 'Y'";
// INCREMENT THE SUITABLE FOR CLAUSE COUNT VARIABLE
$suitable_for_clause_count = $suitable_for_clause_count + 1;
}
else
{
// ADD TO SELECT STATEMENT
$sql_search_statement = $sql_search_statement . " AND suitable_for_gluten_free = 'Y'";
// INCREMENT THE SUITABLE FOR CLAUSE COUNT VARIABLE
$suitable_for_clause_count = $suitable_for_clause_count + 1;
}
}
// ELSE IT HAS NOT BEEN CHECKED
else
{
$gluten_free = 'N';
}
// GET LOW CALORIE SEARCH CRITERIA
$low_calorie = trim($_POST['low_calorie'],"'");
// IF IT HAS BEEN CHECKED...
if($low_calorie == 'on')
{
// SET IT TO 'Y' SO IT REMAINS CHECKED IN THE FORM
$low_calorie = 'Y';
// DETERMINE IF THIS IS FIRST CLAUSE...
if($suitable_for_clause_count == 0 && $meal_clause_count == 0)
{
// ADD TO SELECT STATEMENT
$sql_search_statement = $sql_search_statement . " WHERE suitable_for_low_calorie = 'Y'";
// INCREMENT THE SUITABLE FOR CLAUSE COUNT VARIABLE
$suitable_for_clause_count = $suitable_for_clause_count + 1;
}
else
{
// ADD TO SELECT STATEMENT
$sql_search_statement = $sql_search_statement . " AND suitable_for_low_calorie = 'Y'";
// INCREMENT THE SUITABLE FOR CLAUSE COUNT VARIABLE
$suitable_for_clause_count = $suitable_for_clause_count + 1;
}
}
// ELSE IT HAS NOT BEEN CHECKED
else
{
$low_calorie = 'N';
}
// GET LOW GI SEARCH CRITERIA
$low_gi = trim($_POST['low_gi'],"'");
// IF IT HAS BEEN CHECKED...
if($low_gi == 'on')
{
// SET IT TO 'Y' SO IT REMAINS CHECKED IN THE FORM
$low_gi = 'Y';
// DETERMINE IF THIS IS FIRST CLAUSE...
if($suitable_for_clause_count == 0 && $meal_clause_count == 0)
{
// ADD TO SELECT STATEMENT
$sql_search_statement = $sql_search_statement . " WHERE suitable_for_low_gi = 'Y'";
// INCREMENT THE SUITABLE FOR CLAUSE COUNT VARIABLE
$suitable_for_clause_count = $suitable_for_clause_count + 1;
}
else
{
// ADD TO SELECT STATEMENT
$sql_search_statement = $sql_search_statement . " AND suitable_for_low_gi = 'Y'";
// INCREMENT THE SUITABLE FOR CLAUSE COUNT VARIABLE
$suitable_for_clause_count = $suitable_for_clause_count + 1;
}
}
// ELSE IT HAS NOT BEEN CHECKED
else
{
$low_gi = 'N';
}
// GET HIGH FIBRE SEARCH CRITERIA
$high_fibre = trim($_POST['high_fibre'],"'");
// IF IT HAS BEEN CHECKED...
if($high_fibre == 'on')
{
// SET IT TO 'Y' SO IT REMAINS CHECKED IN THE FORM
$high_fibre = 'Y';
// DETERMINE IF THIS IS FIRST CLAUSE...
if($suitable_for_clause_count == 0 && $meal_clause_count == 0)
{
// ADD TO SELECT STATEMENT
$sql_search_statement = $sql_search_statement . " WHERE suitable_for_high_fibre = 'Y'";
// INCREMENT THE SUITABLE FOR CLAUSE COUNT VARIABLE
$suitable_for_clause_count = $suitable_for_clause_count + 1;
}
else
{
// ADD TO SELECT STATEMENT
$sql_search_statement = $sql_search_statement . " AND suitable_for_high_fibre = 'Y'";
// INCREMENT THE SUITABLE FOR CLAUSE COUNT VARIABLE
$suitable_for_clause_count = $suitable_for_clause_count + 1;
}
}
// ELSE IT HAS NOT BEEN CHECKED
else
{
$high_fibre = 'N';
}
// GET NUT FREE SEARCH CRITERIA
$nut_free = trim($_POST['nut_free'],"'");
// IF IT HAS BEEN CHECKED...
if($nut_free == 'on')
{
// SET IT TO 'Y' SO IT REMAINS CHECKED IN THE FORM
$nut_free = 'Y';
// DETERMINE IF THIS IS FIRST CLAUSE...
if($suitable_for_clause_count == 0 && $meal_clause_count == 0)
{
// ADD TO SELECT STATEMENT
$sql_search_statement = $sql_search_statement . " WHERE suitable_for_nut_free = 'Y'";
// INCREMENT THE SUITABLE FOR CLAUSE COUNT VARIABLE
$suitable_for_clause_count = $suitable_for_clause_count + 1;
}
else
{
// ADD TO SELECT STATEMENT
$sql_search_statement = $sql_search_statement . " AND suitable_for_nut_free = 'Y'";
// INCREMENT THE SUITABLE FOR CLAUSE COUNT VARIABLE
$suitable_for_clause_count = $suitable_for_clause_count + 1;
}
}
// ELSE IT HAS NOT BEEN CHECKED
else
{
$nut_free = 'N';
}
// GET PREGNANCY SEARCH CRITERIA
$pregnancy = trim($_POST['pregnancy'],"'");
// IF IT HAS BEEN CHECKED...
if($pregnancy == 'on')
{
// SET IT TO 'Y' SO IT REMAINS CHECKED IN THE FORM
$pregnancy = 'Y';
// DETERMINE IF THIS IS FIRST CLAUSE...
if($suitable_for_clause_count == 0 && $meal_clause_count == 0)
{
// ADD TO SELECT STATEMENT
$sql_search_statement = $sql_search_statement . " WHERE suitable_for_pregnancy = 'Y'";
// INCREMENT THE SUITABLE FOR CLAUSE COUNT VARIABLE
$suitable_for_clause_count = $suitable_for_clause_count + 1;
}
else
{
// ADD TO SELECT STATEMENT
$sql_search_statement = $sql_search_statement . " AND suitable_for_pregnancy = 'Y'";
// INCREMENT THE SUITABLE FOR CLAUSE COUNT VARIABLE
$suitable_for_clause_count = $suitable_for_clause_count + 1;
}
}
// ELSE IT HAS NOT BEEN CHECKED
else
{
$pregnancy = 'N';
}
// GET EGG FREE SEARCH CRITERIA
$egg_free = trim($_POST['egg_free'],"'");
// IF IT HAS BEEN CHECKED...
if($egg_free == 'on')
{
// SET IT TO 'Y' SO IT REMAINS CHECKED IN THE FORM
$egg_free = 'Y';
// DETERMINE IF THIS IS FIRST CLAUSE...
if($suitable_for_clause_count == 0 && $meal_clause_count == 0)
{
// ADD TO SELECT STATEMENT
$sql_search_statement = $sql_search_statement . " WHERE suitable_for_egg_free = 'Y'";
// INCREMENT THE SUITABLE FOR CLAUSE COUNT VARIABLE
$suitable_for_clause_count = $suitable_for_clause_count + 1;
}
else
{
// ADD TO SELECT STATEMENT
$sql_search_statement = $sql_search_statement . " AND suitable_for_egg_free = 'Y'";
// INCREMENT THE SUITABLE FOR CLAUSE COUNT VARIABLE
$suitable_for_clause_count = $suitable_for_clause_count + 1;
}
}
// ELSE IT HAS NOT BEEN CHECKED
else
{
$egg_free = 'N';
}
/************************/
/************************/
/***** TIME OPTIONS *****/
/************************/
/************************/
// INITIATE TIME CLAUSE COUNT
$time_clause_count = 0;
// GET UNDER 20 MINUTES CRITERIA
$under = trim($_POST['under'],"'");
// IF IT HAS BEEN CHECKED...
if($under == 'on')
{
// SET IT TO 'Y' SO IT REMAINS CHECKED IN THE FORM
$under = 'Y';
// IF NO CLAUSES HAVE BEEN INCREMENTED...
if($time_clause_count == 0 && $suitable_for_clause_count == 0 && $meal_clause_count == 0)
{
// ADD TO SELECT STATEMENT
$sql_search_statement = $sql_search_statement . " WHERE (time = 'U'";
// INCREMENT THE TIME CLAUSE COUNT VARIABLE
$time_clause_count = $time_clause_count + 1;
}
// IF ONLY THE TIME CLAUSE COUNT HAS BEEN INCREMENTED
elseif($time_clause_count != 0)
{
// ADD TO SELECT STATEMENT
$sql_search_statement = $sql_search_statement . " OR time = 'U'";
// INCREMENT THE TIME CLAUSE COUNT VARIABLE
$time_clause_count = $time_clause_count + 1;
}
else
{
// ADD TO SELECT STATEMENT
$sql_search_statement = $sql_search_statement . " AND (time = 'U'";
// INCREMENT THE TIME CLAUSE COUNT VARIABLE
$time_clause_count = $time_clause_count + 1;
}
}
// ELSE IT HAS NOT BEEN CHECKED
else
{
$under = 'N';
}
// GET BETWEEN 20 AND 45 MINUTES CRITERIA
$between = trim($_POST['between'],"'");
// IF IT HAS BEEN CHECKED...
if($between == 'on')
{
// SET IT TO 'Y' SO IT REMAINS CHECKED IN THE FORM
$between = 'Y';
// IF NO CLAUSES HAVE BEEN INCREMENTED...
if($time_clause_count == 0 && $suitable_for_clause_count == 0 && $meal_clause_count == 0)
{
// ADD TO SELECT STATEMENT
$sql_search_statement = $sql_search_statement . " WHERE (time = 'B'";
// INCREMENT THE TIME CLAUSE COUNT VARIABLE
$time_clause_count = $time_clause_count + 1;
}
// IF THE TIME CLAUSE COUNT HAS BEEN INCREMENTED...
elseif($time_clause_count != 0)
{
// ADD TO SELECT STATEMENT
$sql_search_statement = $sql_search_statement . " OR time = 'B'";
// INCREMENT THE TIME CLAUSE COUNT VARIABLE
$time_clause_count = $time_clause_count + 1;
}
else
{
// ADD TO SELECT STATEMENT
$sql_search_statement = $sql_search_statement . " AND (time = 'B'";
// INCREMENT THE TIME CLAUSE COUNT VARIABLE
$time_clause_count = $time_clause_count + 1;
}
}
// ELSE IT HAS NOT BEEN CHECKED
else
{
$between = 'N';
}
// GET OVER 45 MINUTES CRITERIA
$over = trim($_POST['over'],"'");
// IF IT HAS BEEN CHECKED...
if($over == 'on')
{
// SET IT TO 'Y' SO IT REMAINS CHECKED IN THE FORM
$over = 'Y';
// IF NO CLAUSES HAVE BEEN INCREMENTED...
if($time_clause_count == 0 && $suitable_for_clause_count == 0 && $meal_clause_count == 0)
{
// ADD TO SELECT STATEMENT
$sql_search_statement = $sql_search_statement . " WHERE (time = 'O'";
// INCREMENT THE TIME CLAUSE COUNT VARIABLE
$time_clause_count = $time_clause_count + 1;
}
// IF THE TIME CLAUSE COUNT HAS BEEN INCREMENTED...
elseif($time_clause_count != 0)
{
// ADD TO SELECT STATEMENT
$sql_search_statement = $sql_search_statement . " OR time = 'O'";
// INCREMENT THE TIME CLAUSE COUNT VARIABLE
$time_clause_count = $time_clause_count + 1;
}
else
{
// ADD TO SELECT STATEMENT
$sql_search_statement = $sql_search_statement . " AND (time = 'O'";
// INCREMENT THE TIME CLAUSE COUNT VARIABLE
$time_clause_count = $time_clause_count + 1;
}
}
// ELSE IT HAS NOT BEEN CHECKED
else
{
$over = 'N';
}
// IF THE AT LEAST ONE TIME CLAUSE OPTION HAS BEEN SELECTED...
if($time_clause_count != 0)
{
// CONCATENATE A CLOSING BRACE ON THE END OF THE SELECT STATEMENT
$sql_search_statement = $sql_search_statement . ")";
}

/************************/
/************************/
/***** SKILL OPTIONS ****/
/************************/
/************************/
// INITIATE THE SKILL CLAUSE COUNT
$skill_clause_count = 0;
// GET BEGINNER CRITERIA
$beginner = trim($_POST['beginner'],"'");
// IF IT HAS BEEN CHECKED...
if($beginner == 'on')
{
// SET IT TO 'Y' SO IT REMAINS CHECKED IN THE FORM
$beginner = 'Y';

// IF NO CLAUSES HAVE BEEN INCREMENTED...
if($skill_clause_count == 0 && $time_clause_count == 0 && $suitable_for_clause_count == 0 && $meal_clause_count == 0)
{
// ADD TO SELECT STATEMENT
$sql_search_statement = $sql_search_statement . " WHERE (skill_level = 'B'";
// INCREMENT THE SKILL CLAUSE COUNT VARIABLE
$skill_clause_count = $skill_clause_count + 1;
}

// IF THE TIME CLAUSE COUNT HAS BEEN INCREMENTED...
elseif($skill_clause_count != 0)
{
// ADD TO SELECT STATEMENT
$sql_search_statement = $sql_search_statement . " OR skill_level = 'B'";
// INCREMENT THE TIME CLAUSE COUNT VARIABLE
$skill_clause_count = $skill_clause_count + 1;
}
else
{
// ADD TO SELECT STATEMENT
$sql_search_statement = $sql_search_statement . " AND (skill_level = 'B'";
// INCREMENT THE TIME CLAUSE COUNT VARIABLE
$skill_clause_count = $skill_clause_count + 1;
}
}
// ELSE IT HAS NOT BEEN CHECKED
else
{
$beginner = 'N';
}
// GET INTERMEDIATE CRITERIA
$improver = trim($_POST['improver'],"'");
// IF IT HAS BEEN CHECKED...
if($improver == 'on')
{
// SET IT TO 'Y' SO IT REMAINS CHECKED IN THE FORM
$improver = 'Y';

// IF NO CLAUSES HAVE BEEN INCREMENTED...
if($skill_clause_count == 0 && $time_clause_count == 0 && $suitable_for_clause_count == 0 && $meal_clause_count == 0)
{
// ADD TO SELECT STATEMENT
$sql_search_statement = $sql_search_statement . " WHERE (skill_level = 'I'";
// INCREMENT THE SKILL CLAUSE COUNT VARIABLE
$skill_clause_count = $skill_clause_count + 1;
}

// IF THE TIME CLAUSE COUNT HAS BEEN INCREMENTED...
elseif($skill_clause_count != 0)
{
// ADD TO SELECT STATEMENT
$sql_search_statement = $sql_search_statement . " OR skill_level = 'I'";
// INCREMENT THE TIME CLAUSE COUNT VARIABLE
$skill_clause_count = $skill_clause_count + 1;
}
else
{
// ADD TO SELECT STATEMENT
$sql_search_statement = $sql_search_statement . " AND (skill_level = 'I'";
// INCREMENT THE TIME CLAUSE COUNT VARIABLE
$skill_clause_count = $skill_clause_count + 1;
}
}
// ELSE IT HAS NOT BEEN CHECKED
else
{
$improver = 'N';
}
// GET ADVANCED CRITERIA
$advanced = trim($_POST['advanced'],"'");
// IF IT HAS BEEN CHECKED...
if($advanced == 'on')
{
// SET IT TO 'Y' SO IT REMAINS CHECKED IN THE FORM
$advanced = 'Y';

// IF NO CLAUSES HAVE BEEN INCREMENTED...
if($skill_clause_count == 0 && $time_clause_count == 0 && $suitable_for_clause_count == 0 && $meal_clause_count == 0)
{
// ADD TO SELECT STATEMENT
$sql_search_statement = $sql_search_statement . " WHERE (skill_level = 'A'";
// INCREMENT THE SKILL CLAUSE COUNT VARIABLE
$skill_clause_count = $skill_clause_count + 1;
}

// IF THE TIME CLAUSE COUNT HAS BEEN INCREMENTED...
elseif($skill_clause_count != 0)
{
// ADD TO SELECT STATEMENT
$sql_search_statement = $sql_search_statement . " OR skill_level = 'A'";
// INCREMENT THE TIME CLAUSE COUNT VARIABLE
$skill_clause_count = $skill_clause_count + 1;
}
else
{
// ADD TO SELECT STATEMENT
$sql_search_statement = $sql_search_statement . " AND (skill_level = 'A'";
// INCREMENT THE TIME CLAUSE COUNT VARIABLE
$skill_clause_count = $skill_clause_count + 1;
}
}
// ELSE IT HAS NOT BEEN CHECKED
else
{
$advanced = 'N';
}
// IF THE AT LEAST ONE SKILL CLAUSE OPTION HAS BEEN SELECTED...
if($skill_clause_count != 0)
{
// CONCATENATE A CLOSING BRACE ON THE END OF THE SELECT STATEMENT
$sql_search_statement = $sql_search_statement . ")";
}
// CONCATENATE SOME FINAL EXPRESSIONS ONTO THE END OF THE SELECT STATEMENT
$sql_search_statement = $sql_search_statement . " AND display_on_site = 'Y' ORDER BY name ASC";
//echo $sql_search_statement;
echo "<div class = 'row'>";
echo "<div class = 'col-lg-3'>";
include("includes/search-menu.php");
echo "</div>";
echo "<div class = 'col-lg-9'>";
$run_search_query = $sql_search_statement;
$search_result = @mysql_query ($run_search_query);
while ($matching_results = mysql_fetch_array($search_result, MYSQL_ASSOC))
{
echo "<h4>$matching_results[name]</h4>";
echo "<p>$matching_results[description]</p>";
echo "<br />";
}
echo "</div>";
echo "</div>";

include("includes/footer.php");
?>