Link to home
Start Free TrialLog in
Avatar of DS928
DS928Flag for United States of America

asked on

Div Not Populating

I have a div that was populating, then it stopped.  Its off of this javascript.

$("#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);
        		}
    			});
				});
    			});	

Open in new window


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>

Open in new window

ASKER CERTIFIED SOLUTION
Avatar of skullnobrains
skullnobrains

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of DS928

ASKER

Found it.  I failed to put the MenuTypeID field in the select part.  Thank you.