|
|
| SEARCH RESULTS 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("SELECT * FROM recipes WHERE title LIKE '%".mysqli_real_escape_string($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 "- ".UCFirst($row[title])."
";
}
?>
$perpage) {
$start2 = $start - ($perpage * 2);
if($start2 < 0) $start2 = 0;
echo " < Previous Page ";
}
if($start < $total) echo " Next Page >";
}
}
?>
|
|
 |
|
|