';
$catsql = "select * from category order by cat_type,category";
$catres = data_query($catsql,__FILE__,__LINE__);
if (isset($ingredient)) {
if ($ingredient=="--") {
unset($ingredient);
}
}
print '
';
switch($page_type) {
case "index";
print "
Index
";
show_tabs($catres,$this_cat,'','','');
print '
';
print '
';
print '
Lucky Dip Recipe
';
$recipesql = 'select * from recipe order by rand()';
$reciperes = data_query($recipesql,__FILE__,__LINE__);
$recipedata=data_fetch_array($reciperes,__FILE__,__LINE__);
one_recipe($recipedata,$myRecipes);
print '
';
print '';
print '
';
print <<These recipes are provided to help stimulate your imagination in using Prenzel products.
Browse through the categories or search for a recipe using specific ingredients.
My Recipes
You may click the link at the bottom of each recipe to add it to you own stored recipebox.
You will need to be able to accept cookies from our site to use this. Your recipe list will be stored in a cookie on your computer for 6 months.
Printing
This site is printer-friendly. Print these pages and you'll get just the recipes.
Use "My Recipes" and greate your own prenzel recipe collection.
eot;
/*
The "Print view" link on each page opens just the recipe page you are currently viewing in a window by itself. This page
is "Printer-friendly". Use this in conjunction with "My Recipes" to greate your own prenzel recipe collection.
eot;
*/
print "
";
print "
";
break;
case "search";
$recipesql = 'select * from recipe ';
$and=" where ";
if (isset($ingredient)) {
$recipesql .= $and.' (name like "%'.$ingredient.'%" ';
$recipesql .= ' or text like "%'.$ingredient.'%") ';
$and=" and ";
}
if ($stext!="") {
$recipesql .= $and.' (name like "%'.addslashes($stext).'%" ';
$recipesql .= ' or text like "%'.addslashes($stext).'%") ';
$and=" and ";
}
if ($scat!="") {
$recipesql .= $and.' (category = "'.$scat.'") ';
}
$recipesql .= 'order by name';
$reciperes = data_query($recipesql,__FILE__,__LINE__);
print '
';
if ($scat!='') {
print $scat;
} else {
print 'Recipes';
}
if (isset($ingredient)) {
print ' containing '.$ingname;
}
print "
";
if ($stext!="") {
print '
';
print 'Matching '.$stext.'
';
}
show_tabs($catres,$this_cat,$page,$path,$query);
break;
case "category";
$recipesql='select * from recipe where category="'.$this_cat.'" order by name';
$reciperes = data_query($recipesql,__FILE__,__LINE__);
print '
'.$this_cat."
";
show_tabs($catres,$this_cat,$page,$path,$query);
break;
case "mine";
$sellist = join(' or recipe_number=',$myRecipes);
if ($sellist!='') {
$sellist = 'where recipe_number='.$sellist;
}
$recipesql='select * from recipe '.$sellist.' order by name';
$reciperes = data_query($recipesql,__FILE__,__LINE__);
print '
My Recipe Box
';
show_tabs($catres,$this_cat,$page,$path,$query);
break;
}
if (($page_type=="search")||($page_type=="category")||($page_type=="mine")) {
if (mysql_num_rows($reciperes)==0) {
print "Sorry no recipes found";
} else {
if (($page_type=="mine")) {
if (count($myRecipes)==0){
print "Sorry no recipes found";
} else {
display_recipes($reciperes,$page,$path,$query,$myRecipes);
}
} else {
if (isset($this_cat)){
$path='./'.str_replace(' ','_',trim(strtolower($this_cat)));
} else {
$path='./recipes';
}
$query='';
if ($page_type=="search"){
if (!isset($ingredient)) {$ingredient='';};
$query = '?ingredient='.$ingredient;
$query .= '&stext='.$stext;
$query .= '&scat='.$scat;
}
display_recipes($reciperes,$page,$path,$query,$myRecipes);
}
}
}
?>