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)