Solved

Div Not Populating

Posted on 2013-05-18
2
417 Views
Last Modified: 2013-05-18
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

0
Comment
Question by:DS928
2 Comments
 
LVL 26

Accepted Solution

by:
skullnobrains earned 500 total points
ID: 39177438
you need some more debugging.

uncoment the alert in the js code during the debug time and add a failure callback so you can tell wether you're not getting the proper data or no data at all, or possibly the ajax query never fired
0
 

Author Closing Comment

by:DS928
ID: 39177445
Found it.  I failed to put the MenuTypeID field in the select part.  Thank you.
0

Featured Post

Optimizing Cloud Backup for Low Bandwidth

With cloud storage prices going down a growing number of SMBs start to use it for backup storage. Unfortunately, business data volume rarely fits the average Internet speed. This article provides an overview of main Internet speed challenges and reveals backup best practices.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

These days socially coordinated efforts have turned into a critical requirement for enterprises.
This article demonstrates how to create a simple responsive confirmation dialog with Ok and Cancel buttons using HTML, CSS, jQuery and Promises
The viewer will learn how to look for a specific file type in a local or remote server directory using PHP.
The viewer will the learn the benefit of plain text editors and code an HTML5 based template for use in further tutorials.

770 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question