DS928
asked on
Div Not Populating
I have a div that was populating, then it stopped. Its off of this javascript.
I tested the querys that it invokes and they all work fine. Here is the php file.
$("#Menus").click(function()
{
var Lid = $("#Restaurant").val();
var MenuTypeId = $(this).val();
$.ajax({
type: "POST",
url: "../Scripts/result_menus_new.php",
data: {"Lid": Lid,"MenuTypeId": MenuTypeId},
cache: false,
success: function (html) {
//alert (Menus);
$("#MyMenus").html(html);
}
});
});
});
I tested the querys that it invokes and they all work fine. Here is the php file.
<div id=BigName>
<?PHP
include("config.php");
$Lid=$_POST['Lid']= mysql_real_escape_string($_POST['Lid']);
$MenuTypeId=$_POST['MenuTypeId']= mysql_real_escape_string($_POST['MenuTypeId']);
//$Lid = $_POST['Lid'];
//$MenuTypeId = $_POST['MenuTypeId'];
//select menu type
$run = mysql_query("select * from tblMenuType where MenuTypeID='$MenuTypeId'") or die(mysql_error());
$row = mysql_fetch_array($run) or die(mysql_error());
$menu_type_name = $row['MenuTypeName'];
if(!$rs=mysql_query("SELECT tblRestaurants.RestName
FROM
tblRestaurants
INNER JOIN tblLocations ON tblRestaurants.RestID = tblLocations.RestID
WHERE tblLocations.LocationID = '$Lid'")) {
echo "Cannot parse query";
}
else
{
echo "<table id=\"BigName\" class =\"BigName\" table width=\"450\" align=\"Center\" cellspacing=\"0\">\n";
while($row = mysql_fetch_array($rs)) {
echo "<tr><strong><td align='center' style='padding-top: 10px;'>".$row['RestName']."</td></strong></tr>";}
echo "</tr>\n";
}
?>
</div>
<div id=BigPhone>
<?PHP
if(!$rs=mysql_query("SELECT tblLocations.Phone
FROM
tblLocations
WHERE tblLocations.LocationID = '$Lid'")) {
echo "Cannot parse query";
}
else
{
echo "<table id=\"BigPhone\" class =\"BigPhone\" table width=\"450\" align=\"Center\" cellspacing=\"0\">\n";
while($row = mysql_fetch_array($rs)) {
echo "<tr><strong><td align='center' style='padding-top: 10px;'>".$row['Phone']."</td></strong></tr>";
}
echo "<tr><strong><td align='center' style='padding-top: 10px;'>".$menu_type_name."</td></strong></tr>";
echo "</tr>\n";
}
?>
</div>
<div id="MyMenus">
<?php
if(!$rs=mysql_query("SELECT tblMenuItems.ItemName, tblMenus.ItemPrice,tblMenuCat.CatName
FROM tblMenuItems
INNER JOIN tblMenus ON tblMenuItems.ItemID = tblMenus.ItemID
INNER JOIN tblLocMenu ON tblLocMenu.MenuID = tblMenus.MenuID
INNER JOIN tblMenuCat ON tblMenus.ItemCat = tblMenuCat.CatID
WHERE tblLocMenu.LocationID = '$Lid' AND tblMenus.MenuTypeId = '$MenuTypeId'
GROUP BY tblMenus.ItemID")) {
echo "Cannot parse query";
}
else
{
echo "<table id=\"MyMenus\" table width=\"200\" align=\"Center\" cellspacing=\"0\">\n";
echo "<tbody>";
$Cat="";
while($row = mysql_fetch_array($rs)) {
If($Cat!=$row['CatName']){
echo "<tr><strong><td align='left' style='padding-top: 10px;'>".$row['CatName']."</td></strong></tr>";
}
$Cat=$row['CatName'];
echo "<tr>";
echo "<td align='left' style='padding-left: 25px;'}>".$row['ItemName']."</td>";
echo "<td align='right'>".$row['ItemPrice']."</td>";
echo "</tr>\n";
echo "</tbody>";
}
}
?>
</div>
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER