Changing Querys For Dropdown ListBox

DSTR3 · January 11, 2013

I have 5 buttons. When you click on one, it populates the listbox. The first one works, however I am at loss on how to get the other 4 to work. Any help is appreciated.

<?php
$dbc = mysql_connect('','',')
 or die('Error connecting to MySQL server.');
mysql_select_db('MyHead');
$place = mysql_query("select * from tblRestaurants order by RestName ASC");
$cuicine = mysql_query("select * from tblCuisines order by CuisineName ASC");
$city = mysql_query("select * from tblCities order by CityName ASC");
$state = mysql_query("select * from tblStates order by StateName ASC");
$zipcode = mysql_query("select * from tblLocations order by ZipCodeName ASC");
while ($nt= mysql_fetch_assoc($place))
   $arrData[] = $nt;
if(isset($_GET["ajax"]))
{
   echo json_encode($arrData);
   //die();
}
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en">
<head>
   <script src="//ajax.googleapis.com/ajax/libs/jquery/1.8.0/jquery.min.js" type="text/javascript"></script>
   <script type="text/javascript">
function displayPlace()
{
   $.getJSON("index.php?ajax=true", function(data) {
    $.each(data, function(index, objRecord) {
	    var option=document.createElement("option");
	    option.value=objRecord.RestID;
	    option.text=objRecord.RestName;
	    $("#Doggie").append('<option value="' + objRecord.RestID + '">' + objRecord.RestName + '</option>');
    });
   });
}
function displayCuisine()
{
   $.getJSON("index.php?ajax=true", function(data) {
    $.each(data, function(index, objRecord) {
	    var option=document.createElement("option");
	    option.value=objRecord.CuisineID;
	    option.text=objRecord.CuisineName;
	    $("#Doggie").append('<option value="' + objRecord.CuisineID + '">' + objRecord.CuisineName + '</option>');
    });
   });
}
   </script>
   <title>SEARCH</title>
</head>
<body>
    <form>
    <button type="button" onclick="javascript:displayPlace();">Place</button>
    <button type="button" onclick="javascript:displayCuisine();">Cuisine</button>
    <button type="button" onclick="javascript:displayCity();">City</button>
    <button type="button" onclick="javascript:displayState();">State</button>
    <button type="button" onclick="javascript:displayZipCode();">Area</button>
    <br />

    <select name="Doggie" id="Doggie"></select>

    <br />
   </form>
</body>
</html>

Sign In

Changing Querys For Dropdown ListBox

Recommended Posts

DSTR3

Link to comment

Share on other sites

Archived

Browse

Activity

Important Information