Solved

Div Not Populating

Posted on 2013-05-18
2
419 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 27

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

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

This article discusses how to create an extensible mechanism for linked drop downs.
Originally, this post was published on Monitis Blog, you can check it here . Websites are getting bigger and more complicated by the day. Video, images and custom fonts are all great for showcasing your product or service. But the price to pay in…
In this tutorial viewers will learn how to code links for mobile sites that, once clicked, send a call or text to a specified number. For a telephone link (once clicked, calls a number), begin with a normal "<a href=" link tag. For the href, specify…
The viewer will the learn the benefit of plain text editors and code an HTML5 based template for use in further tutorials.

730 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