|
Starters\n";
$query1 = mysql_query ('SELECT * FROM `Menu` WHERE `CatId`= 1');
$query2 = mysql_query ('SELECT ExtraInfo FROM `CatID` WHERE `CatId`= 1');
while ($row = mysql_fetch_array ($query2)) {
if ($row[ExtraInfo]) {echo " " . $row[ExtraInfo] . " \n";} } while ($row = mysql_fetch_array ($query1)) { echo " " . $row[MenuName] . " \n"; } break; case 'piz': echo " Speciality Pizza \n"; $query1 = mysql_query ('SELECT * FROM `Menu` WHERE `CatId`= 3'); $query2 = mysql_query ('SELECT ExtraInfo FROM `CatID` WHERE `CatId`= 3'); while ($row = mysql_fetch_array ($query2)) { echo "" . $row[ExtraInfo] . ""; } while ($row = mysql_fetch_array ($query1)) { echo " " . $row[MenuName] . " \n"; } break; case 'sal': echo " Salads \n"; $query1 = mysql_query ('SELECT * FROM `Menu` WHERE `CatId`= 4'); $query2 = mysql_query ('SELECT ExtraInfo FROM `CatID` WHERE `CatId`= 4'); while ($row = mysql_fetch_array ($query2)) { echo "" . $row[ExtraInfo] . ""; } while ($row = mysql_fetch_array ($query1)) { echo " " . $row[MenuName] . " \n"; } break; case 'san': echo " Sandwiches \n"; $query1 = mysql_query ('SELECT * FROM `Menu` WHERE `CatId`= 9'); $query2 = mysql_query ('SELECT ExtraInfo FROM `CatID` WHERE `CatId`= 9'); while ($row = mysql_fetch_array ($query2)) { echo "" . $row[ExtraInfo] . ""; } while ($row = mysql_fetch_array ($query1)) { echo " " . $row[MenuName] . " \n"; } break; case 'bur': echo " Burgers \n"; $query1 = mysql_query ('SELECT * FROM `Menu` WHERE `CatId`= 8'); $query2 = mysql_query ('SELECT ExtraInfo FROM `CatID` WHERE `CatId`= 8'); while ($row = mysql_fetch_array ($query2)) { echo "" . $row[ExtraInfo] . ""; } while ($row = mysql_fetch_array ($query1)) { echo " " . $row[MenuName] . " \n"; } break; case 'pan': echo " Paninis \n"; $query1 = mysql_query ('SELECT * FROM `Menu` WHERE `CatId`= 7'); $query2 = mysql_query ('SELECT ExtraInfo FROM `CatID` WHERE `CatId`= 7'); while ($row = mysql_fetch_array ($query2)) { echo "" . $row[ExtraInfo] . ""; } while ($row = mysql_fetch_array ($query1)) { echo " " . $row[MenuName] . " \n"; } break; case 'spe': echo " Specialities \n"; $query1 = mysql_query ('SELECT * FROM `Menu` WHERE `CatId`= 5'); $query2 = mysql_query ('SELECT ExtraInfo FROM `CatID` WHERE `CatId`= 5'); while ($row = mysql_fetch_array ($query2)) { echo "" . $row[ExtraInfo] . ""; } while ($row = mysql_fetch_array ($query1)) { echo " " . $row[MenuName] . " \n"; } break; case 'sea': echo " Seafood \n"; $query1 = mysql_query ('SELECT * FROM `Menu` WHERE `CatId`= 6'); $query2 = mysql_query ('SELECT ExtraInfo FROM `CatID` WHERE `CatId`= 6'); while ($row = mysql_fetch_array ($query2)) { echo "" . $row[ExtraInfo] . ""; } while ($row = mysql_fetch_array ($query1)) { echo " " . $row[MenuName] . " \n"; } break; case 'win': echo " Wings \n"; $query1 = mysql_query ('SELECT * FROM `Menu` WHERE `CatId`= 2'); $query2 = mysql_query ('SELECT ExtraInfo FROM `CatID` WHERE `CatId`= 4'); while ($row = mysql_fetch_array ($query2)) { echo "" . $row[ExtraInfo] . ""; } while ($row = mysql_fetch_array ($query1)) { echo " " . $row[MenuName] . " \n"; } break; case 'pas': echo " Pasta \n"; $query1 = mysql_query ('SELECT * FROM `Menu` WHERE `CatId`= 12'); $query2 = mysql_query ('SELECT ExtraInfo FROM `CatID` WHERE `CatId`= 12'); while ($row = mysql_fetch_array ($query2)) { echo "" . $row[ExtraInfo] . ""; } while ($row = mysql_fetch_array ($query1)) { echo " " . $row[MenuName] . " \n"; } break; default: echo " Starters \n"; $query1 = mysql_query ('SELECT * FROM `Menu` WHERE `CatId`= 1'); $query2 = mysql_query ('SELECT ExtraInfo FROM `CatID` WHERE `CatId`= 1'); while ($row = mysql_fetch_array ($query2)) { if ($row[ExtraInfo]) {echo "" . $row[ExtraInfo] . " ";} } while ($row = mysql_fetch_array ($query1)) { echo "" . $row[MenuName] . " \n"; } break; } ?> |
