require("dbinit.php");
if ($Filtered!="Yes")
{
$Asian = $African = $American = $Brunch = $Caucasian = $European = "Yes";
$Indian = $Italian = $Latin = $Russian = $Seafood = $Seattle = $KwikEatz = $Frogean = "Yes";
}
$Query = "(" . ($Descr!="" ? " Cheers LIKE '%" . $Descr . "%' " .
" OR Name LIKE '%" . $Descr . "%' " .
" OR Metro LIKE '%" . $Descr . "%' " .
" OR Address LIKE '%" . $Descr . "%' " .
" OR Phone LIKE '%" . $Descr . "%' " .
" OR Hours LIKE '%" . $Descr . "%' " .
" OR Jeers LIKE '%" . $Descr . "%') AND (" : "") .
($Asian=="Yes" ? " Category = 'Asian' OR " : "") .
($African=="Yes" ? " Category = 'African' OR " : "") .
($American=="Yes" ? " Category = 'American' OR " : "") .
($Brunch=="Yes" ? " Category = 'Brunch' OR " : "") .
($Caucasian=="Yes" ? " Category = 'Caucasian' OR " : "") .
($European=="Yes" ? " Category = 'European' OR " : "") .
($Indian=="Yes" ? " Category = 'Indian' OR " : "") .
($Italian=="Yes" ? " Category = 'Italian' OR " : "") .
($Russian=="Yes" ? " Category = 'Russian' OR " : "") .
($Seafood=="Yes" ? " Category = 'Seafood' OR " : "") .
($Seattle=="Yes" ? " Category = 'Seattle' OR " : "") .
($KwikEatz=="Yes" ? " Category = 'Kwik-Eatz' OR " : "") .
($Latin=="Yes" ? " Category = 'Latin' OR " : "") .
($Frogean=="Yes" ? " Category = 'Frog-ean' OR " : "") . ")";
if (substr($Query, -4)=="OR )")
$Query = substr($Query, 0, -4) . ")";
if ($Query!="")
$Query = " WHERE " . $Query;
// echo "
'" . $Query . "'
";
$result = mysql_query("SELECT * FROM Food " . $Query . " ORDER BY Category", $DBLink);
?>
require("artheader.php");?>
|
for one salad, entree and one coctail per person $ = up to $15 $$ = $15 - $30 $$$ = $30 - $50 $$$ - $50 and up |
| ||||||||||||||
|
|
||||||||||||||
|
| ||||||||||||||