0) $ptitle = UCWords($category)." Category Listing"; else $ptitle = "Recipe for ".$criteria; $pkeys = "recipes,good recipes,easy recipes,recipe database"; $pdesc = "Recipe for ".$criteria.$category; include_once("header_view.php"); $string = ""; if(strlen($category) > 0) { $string = " AND category LIKE '".mysqli_real_escape_string($con,$category)."%'"; } if(strlen($criteria) > 0) { $temp55 = mysqli_query($con,"INSERT INTO recent (term) VALUES ('".mysqli_real_escape_string($con,$criteria)."')"); $temp1 = mysqli_query($con,"SELECT * FROM recipes WHERE title LIKE '%".mysqli_real_escape_string($con,$criteria)."%'$string"); $total = mysqli_num_rows($temp1); } elseif(strlen($string) > 0) { $temp1 = mysqli_query($con,"SELECT * FROM recipes WHERE category LIKE '".mysqli_real_escape_string($con,$category)."%'"); $total = mysqli_num_rows($temp1); } else { $error = "ERROR: You must enter some search criteria.
"; } include_once("header.php"); ?>

RECIPES FOR

( results)

0) echo $error; else { if($total == 0) echo "There are no search results for that criteria, please try again or browse by category on the left."; else { $temp = mysqli_query($con,"SELECT * FROM recipes WHERE title LIKE '%".mysqli_real_escape_string($con,$criteria)."%'$string ORDER BY title LIMIT $start, $perpage"); while($row = mysqli_fetch_array($temp)) { $title = str_replace(" ", "-", $row['title']); $title = str_replace("/", "-", $title); $title = str_replace("*", "", $title); $title = str_replace("'", "", $title); $title = str_replace("\"", "", $title); $title = str_replace("(", "", $title); $title = str_replace(")", "", $title); $title = str_replace("#", "", $title); $title = str_replace("&", "", $title); $title = str_replace("$", "", $title); $title = str_replace("!", "", $title); $title = str_replace("�", "", $title); $title = str_replace("@", "", $title); $title = str_replace("+", "", $title); $title = str_replace("[", "", $title); $title = str_replace("]", "", $title); $title = str_replace("\\", "", $title); echo " ".strtoupper($row['title'])."
"; } ?>