Dynamic Dropdown Box

107 100+

I want to have a dynamic dropdown box whose entries would depend on the selection of an entry in the first dropdown box. BUT the second dropdown box should not reload, only the entries inside should get refreshed or reloaded.

i have a piece of code to create a dynamic dropdown box from w3schools.com but it has the problem of reloading the second dropdown box as well. Please see my code:

Expand|Select|Wrap|Line Numbers

 
//index.php

<html>

<head>

<script language="javascript" type="text/javascript">

var xmlHttp;function showUser(str)

{ 

xmlHttp=GetXmlHttpObject();

if (xmlHttp==null)

 {

 alert ("Browser does not support HTTP Request");

 return;

 }

var url="getdept.php";

url=url+"?c="+str;

url=url+"&sid="+Math.random();

xmlHttp.onreadystatechange=stateChanged;

xmlHttp.open("GET",url,true);

xmlHttp.send(null);

}function stateChanged() 

{ 

if (xmlHttp.readyState==4 || xmlHttp.readyState=="complete")

 { 

 document.getElementById("txtHint").innerHTML=xmlHttp.responseText;

 } 

}function GetXmlHttpObject()

{

var xmlHttp=null;

try

 {

 // Firefox, Opera 8.0+, Safari

 xmlHttp=new XMLHttpRequest();

 }

catch (e)

 {

 //Internet Explorer

 try

  {

  xmlHttp=new ActiveXObject("Msxml2.XMLHTTP");

  }

 catch (e)

  {

  xmlHttp=new ActiveXObject("Microsoft.XMLHTTP");

  }

 }

return xmlHttp;

}

</script>

</head>

<body><form> 

Select a User:

<select name="category" onchange="showUser(this.value)">

<option value="Ministry">Ministry</option>

<option value="Department">Department</option>

<option value="District">District</option>

<option value="Corporation">Corporation</option>

<option value="NGOs">NGOs</option>

<option value="Others">Others</option>

</select>

</form><p>

<div id="txtHint"><b>&nbsp;</b></div>

</p></body>

</html>
 
//getdept.php

<?php

$c=$_GET["c"];
 
$con = mysql_connect('localhost', 'root', 'root');

if (!$con)

 {

 die('Could not connect: ' . mysql_error());

 }
 
mysql_select_db("db", $con);
 
$sql="SELECT * FROM tblagency WHERE category = '".$c."'";
 
$result = mysql_query($sql);

echo "<select name=\"agency\">";

while($row = mysql_fetch_array($result))

 {
 
echo "<option value=".$row['id'].">".$row['agency']."</option>";
 
}

echo "</select>";

mysql_close($con);

?>

So, as shown above in the <div id="txtHint"><b> </b></div> area i want to have a pre-present dropdown box and when the uses selects an entry in the first dropdown box, the second dropdown box entries should be changed but not the dropdown box as a whole. Please advice me!

May 12 '09 #1

Subscribe Post Reply

3967

Ciary

247

Expert 100+

so, if i get it right, all you want to do is select a value from a select using javascript. am i correct?

you might concider looking it up on google. i got 17.100.000 hits so i guess you'll find what you need.

from what i saw, there isn't just one function to select the appropriate value. you'll have to loop through it and find the value you're looking for. then, you can set the value by the .selectedIndex property.

to change the options in the selectbox, you'll probably have to add and delete the options. this can be done by appendChild and removeChild.

i hope that helped

May 12 '09 #2

acoder

16,027

Expert Mod 8TB

First remove the current options:

Expand|Select|Wrap|Line Numbers

selObj.options.length = 0;

then add the options (using a loop)

Expand|Select|Wrap|Line Numbers

selObj.options[i] = new Option(text, value);

This means you will need to change the PHP code to echo appropriate output.

May 12 '09 #3

by: Bob Alston | last post by:

In 2002, "GrayJay" posted the following code: I did this in a jazz record catalogue to find composers - On a form "frmComposers" Create a text box - txtFindComposer, and add the following sub...

Microsoft Access / VBA

Events not firing (First time only) in a dynamic user control. Please help.

by: Shourie | last post by:

I've noticed that none of the child controls events are firing for the first time from the dynamic user control. Here is the event cycle. 1) MainPage_load 2) User control1_Load user clicks a...

ASP.NET

viewstate and dynamic table

by: russ | last post by:

Hi all, Here's a problem I'm having with a dynamic table. Following the guidelines here (http://www.codeproject.com/aspnet/dynamiccontrols.asp), which make perfect sense. The problem is that...

ASP.NET

Form Submit, Dynamic Dropdown

by: Jeff Uchtman | last post by:

I know I have done this but my mind is fried. I have a dynamic dropdown in a form. I need to pull both the dynamic dropdown's ID and name listed in the dropdown. Need a little help with grey...

ASP / Active Server Pages

dynamic datagrid dropdown valuechanged repopulate 2nd list editmo

by: cindy | last post by:

I have a dynamic datagrid. I have custom classes for the controls public class CreateEditItemTemplateDDL : ITemplate { DataTable dtBind; string strddlName; string strSelectedID; string...

ASP.NET

creating dynamic controls out of static controls

by: Tarscher | last post by:

hi all, I have this seemingly simple problem. I have lost a lot of time on it though. When a user selects a value from a dropdownlist (static control) a dynamic control is generated. I have...

ASP.NET

Creating a dynamic drop down menu

by: phpnewbie2007 | last post by:

I have 2 dynamic PHP dropdowns: The second dropdown populates from the first, depending on what is selected in the first. The page is showing issues in a department: The first dropdown...

PHP

Create Dynamic Dropdownlist Controls and related event - ASP.NET

by: MaryamSh | last post by:

Hi, I am creating a Dynamic Search in my application. I create a user control and in Page_load event I create a dynamic dropdownlist and 2 dynamic button (Add,Remove) By pressing Add button...

.NET Framework

Create Dynamic Dropdownlist Controls and related event

by: MaryamSh | last post by:

Create Dynamic Dropdownlist Controls and related event -------------------------------------------------------------------------------- Hi, I am creating a Dynamic Search in my application. I...

.NET Framework

Migrating Website to Cloud - Emmanuel Katto

by: emmanuelkatto | last post by:

Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel

General

Navigating the Data Structures and Algorithms (DSA)

by: BarryA | last post by:

What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...

Algorithms / Advanced Math

How to build RAID in BIOS?

by: Hystou | last post by:

There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

Computer Hardware

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...

Windows Server

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...

C / C++

The easy way to turn off automatic updates for Windows 10/11

by: Hystou | last post by:

Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...

Windows Server

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

by: tracyyun | last post by:

Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...

General

AI Job Threat for Devs

by: agi2029 | last post by:

Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...

Career Advice

Access Europe - Using VBA to create a class based on a table - Wed 1 May

by: isladogs | last post by:

The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...

Microsoft Access / VBA

Dynamic Dropdown Box

Similar topics