|
" . $row[MenuItem] . " ";
if (($row[ExtraInfo]) != "") {
echo "" . $row[ExtraInfo] . "";
}
echo " | ";
if ((($row[Price1]) != "") && (($row[Price2]) == "0.00")) {
echo " " . $row[Price1] . " ";
if (($row[ExtraPriceInfo]) != "") {
echo " " . $row[ExtraPriceInfo] . " ";
}
echo " | ";
} else
if (($row[Price2]) != "0.00") {
echo " " . $row[Price1] . " " . $row[Price2] . " | ";
}
echo "\n";
}
//Sandwiches with 2 sizes
$query2 = mysql_query ("SELECT * FROM menu RIGHT OUTER JOIN Size ON Size.Size=menu.Size WHERE menu.CatId=5");
while ($row = mysql_fetch_array ($query2)) {
echo " " . $row[MenuItem] . " ";
if (($row[ExtraInfo]) != "") {
echo "" . $row[ExtraInfo] . "";
}
echo " | ";
echo " " . $row[SizeName1] . " " . $row[Price1] . " " . $row[SizeName2] . " " . $row[Price2] . " ";
if (($row[SizeName3]) != "") {
echo " " . $row[SizeName3] . " " . $row[Price3] . " ";
}
echo " |
\n";
}
//Meatball and Sausage
$query2 = mysql_query ("SELECT * FROM menu RIGHT OUTER JOIN Size ON Size.Size=menu.Size WHERE menu.CatId=20 AND menu.MenuId != 186");
while ($row = mysql_fetch_array ($query2)) {
echo " " . $row[MenuItem] . "
";
if (($row[ExtraInfo]) != "") {
echo "" . $row[ExtraInfo] . "";
}
echo " | ";
echo " " . $row[SizeName1] . " " . $row[Price1] . " " . $row[SizeName2] . " " . $row[Price2] . "
";
echo $row[SizeName1] . " " . $row[Price3] . " " . $row[SizeName2] . " " . $row[Price4] . " ";
echo " |
\n";
}
//Veal Cutlet
$query1 = mysql_query ('SELECT * FROM `menu` WHERE (`CatId`= 20 AND MenuId = 186)');
while ($row = mysql_fetch_array ($query1)) {
echo " " . $row[MenuItem] . " ";
echo "" . $row[ExtraInfo] . "
" . $row[ExtraPriceInfo] . " | ";
echo " " . $row[Price1] . "
" . $row[Price2] . " ";
echo " |
\n";
}
//ANGUS
echo "
Eddie's Specialty Burgers |
";
echo "All Burgers are ½ Angus Beef served with cool tomato, crisp lettace and raw onion |
";
$query1 = mysql_query ('SELECT * FROM `menu` WHERE `CatId`= 22');
while ($row = mysql_fetch_array ($query1)) {
echo " " . $row[MenuItem] . " ";
if (($row[ExtraInfo]) != "") {
echo "" . $row[ExtraInfo] . "";
}
echo " | ";
if ((($row[Price1]) != "") && (($row[Price2]) == "0.00")) {
echo " " . $row[Price1] . " ";
echo " | ";
} else
if (($row[Price2]) != "0.00") {
echo " " . $row[Price1] . " " . $row[Price2] . " | ";
}
echo "
\n";
if (($row[ExtraPriceInfo]) != "") {
echo "" . $row[ExtraPriceInfo] . " |
";
}
}
/* $query2 = mysql_query ("SELECT * FROM menu, AddOns WHERE menu.CatId=AddOns.CatId AND menu.CatId=22");
while ($row = mysql_fetch_array ($query2)) {
echo " " . $row[MenuItem] . " " . $row[Add1] . " | ";
echo " " . $row[AddPrice1] . " |
";
echo " " . $row[Add2] . " | " . $row[AddPrice2] . " ";
echo " |
\n";
} */
//Delis and Subs
echo "
Deli Sandwiches and Subs |
";
$query1 = mysql_query ('SELECT * FROM `menu` WHERE `CatId`= 6 and Size = 0');
while ($row = mysql_fetch_array ($query1)) {
echo " " . $row[MenuItem] . " ";
if (($row[ExtraInfo]) != "") {
echo "" . $row[ExtraInfo] . "";
}
echo " | ";
if ((($row[Price1]) != "") && (($row[Price2]) == "0.00")) {
echo " " . $row[Price1] . " ";
echo " | ";
} else
if (($row[Price2]) != "0.00") {
echo " " . $row[Price1] . " " . $row[Price2] . " | ";
}
echo "
\n";
if (($row[ExtraPriceInfo]) != "") {
echo "" . $row[ExtraPriceInfo] . " |
";
}
}
?>