Village Pizza & Lounge
860.873.1416
a Family Restaurant
Book your party today!! 860-873-1416
Greek
700) OR (sort > 241 AND sort < 267)) ORDER BY `sort`");
}
if($menu_cat == "sandwiches"){
$result = mysqli_query($mysqli, "Select * from `publishednew` WHERE username = '".$username."' AND password = '".$password."' AND (sort > 216 AND sort< 240) OR (sort > 288 AND sort< 341) ORDER BY `sort`");
}
if($menu_cat == "appetizers"){
$result = mysqli_query($mysqli, "Select * from `publishednew` WHERE username = '".$username."' AND password = '".$password."' AND sort > 340 AND sort< 371 ORDER BY `sort`");
}
if($menu_cat == "breakfast"){
$result = mysqli_query($mysqli, "Select * from `publishednew` WHERE username = '".$username."' AND password = '".$password."' AND sort > 72 AND sort< 187 ORDER BY `sort`");
}
if($menu_cat == "desserts"){
$result = mysqli_query($mysqli, "Select * from `publishednew` WHERE username = '".$username."' AND password = '".$password."' AND sort > 504 AND sort < 531 ORDER BY `sort`");
}
if($menu_cat == "drinks"){
$result = mysqli_query($mysqli, "Select * from `publishednew` WHERE username = '".$username."' AND password = '".$password."' AND ((sort > 700) OR (sort > 241 AND sort < 267)) ORDER BY `sort`");
}
if($menu_cat == "seafood"){
$result = mysqli_query($mysqli, "Select * from `publishednew` WHERE username = '".$username."' AND password = '".$password."' AND ((sort > 370 AND sort< 388) OR (sort > 406 AND sort< 427.2)) ORDER BY `sort`");
}
if($menu_cat == "soups"){
$result = mysqli_query($mysqli, "Select * from `publishednew` WHERE username = '".$username."' AND password = '".$password."' AND sort > 266 AND sort< 286 ORDER BY `sort`");
}
if ($mysqli->connect_errno) {
printf("Connect failed: %s\n", $mysqli->connect_error);
exit();
}
//$num=mysqli_num_rows($result);
//$row = mysqli_fetch_array($result, MYSQLI_ASSOC);
echo "
\n";
} else { //////////ASK
echo "".$row[0]." \n";
echo "
".$row[1]."
\n";
}
} else { /// PRICE ========== 0.00
if ($row[29] == "sp_omelet"){
echo "".$row[0]." ".$row[1]."\n";
while (($row = mysqli_fetch_array($result))==true){
if ($row[8] !=""){ ///captions
echo "
"; if ($row[2] == 16780 OR $row[2] == 17110){ echo "\n";
} else {
echo "\n";
}
echo $row[8]." - ".$vert;
$vert = $vert + 35;
echo "
"; $vert = $vert + 5; echo "
".$row[1]."
\n";
} elseif ( $row[29] = "sp_omelet") { // no price - use (Market Price) for pack_code
// echo "sp_ommmmmmmmmmmmmmmmelet";
echo ""; if ($row[2] == 16780 OR $row[2] == 17110){ echo "
- ".$row[8]."
- ".$row[8]."
".$row[10]."
\n";
$vert = $vert +10;
//echo "Caption:". $vert;
}
//////////////////////////////////////////////Temp 4/14
if ($row[0] !=""){ ///desc
// echo ""; $vert = $vert + 5; echo "
\n";
echo "".$row[0]."
".$row[1]."
\n";
//echo "Caption:". $vert;
}
////////// price A PRICEc
/*
if($row[32] != 0.00 AND $row[33] == 0.00 AND $row[34] != 0.00 AND $row[0] !=""){ ////case where there is a small, medium & large price. row[32] is the small size SMALL/LARGE ONLY
echo "".$row[1]."
\n";
if($row[29] == ""){
echo "".$row[0]." . . . . (Regular)-$".$row[32]." . . . . . . .(Deluxe)-$".$row[34]."
".$row[1]."
\n";
} elseif ($row[29] == "pizza") {
echo "".$row[0]." . . . .(SM)-$".$row[32]." . . . .(LG)-$".$row[34]." ".$row[1]."
".$row[1]."
\n";
echo "".$row[0]."
\n";
}
} else { ///
if ($row[0] =="Pizza Toppings" AND $row[1] != ""){ // price only if description - NO PRICE if caption
echo "\n";
echo "".$row[0]."
".$row[1]."
\n";
} elseif($row[32] != 0.00 AND $row[33] != 0.00 AND $row[34] != 0.00 AND $row[0] !=""){ ////case where there is a small & large price. row[32] is the small size
echo "".$row[1]."
\n";
echo "".$row[0]." . . . .(Hard Roll) - $".$row[32]." . . . .(6 Inch) - $".$row[33]." . . . . (12 Inch) - $".$row[34]."
".$row[1]."
\n";
// condition for sp omelettes
// NOT PIZ TOP DESC YES NO CAPTION PACK_CODE not SLIDE
} elseif ($row[0] !="Pizza Toppings" AND $row[0] != "" AND $row[8] == "" AND $row[29] != "slide" AND $row[29] != "sp_omelet") { // no price - use (Market Price) for pack_code
echo "".$row[1]."
\n";
if($row[7] != 0.00){
if($row[0] == "."){
// echo "ppppppppppppppppp";
echo "
"; echo "".$row[0]."".$row[1].";. . . . . . . . . . . . . . . . . . . . . . . . .$".$row[7]."
\n";
} else {
echo "".$row[0]." . . . . . . . . . $".$row[7]." "; echo "".$row[0]."
".$row[1]."
".$row[1]."