ajax script select box is repeated

232 100+

in ajax script
select box is repeated
state 2 times
district 2 times
kindly suggest me to correct this error

Expand|Select|Wrap|Line Numbers

 <html>

<head>

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

var xmlhttp;
 
function showUser(str)

{

xmlhttp=GetXmlHttpObject();

if (xmlhttp==null)

  {

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

  return;

  }

var url="getuser.php";

url=url+"?q="+str;

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

xmlhttp.onreadystatechange=stateChanged;

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

xmlhttp.send(null);

}
 
function stateChanged()

{

if (xmlhttp.readyState==4)

{

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

}

}
 
function GetXmlHttpObject()

{

if (window.XMLHttpRequest)

  {

  // code for IE7+, Firefox, Chrome, Opera, Safari

  return new XMLHttpRequest();

  }

if (window.ActiveXObject)

  {

  // code for IE6, IE5

  return new ActiveXObject("Microsoft.XMLHTTP");

  }

return null;

}

</script>

     <?php require("conn.php");?>

</head>

<body>
 
<?php

//Select a User:
 
$q=$_GET["q"];

if($q=="")

{

$q="assam";

}
 
$sql="SELECT distinct(state) FROM statedistrict";
 
$result = mysql_query($sql);

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

<option value="<?php echo $q; ?>"><?php echo $q; ?></option>

<?php 

while($row = mysql_fetch_array($result))

  {  ?>

 <option value="<?php echo $row[0]; ?>"><?php echo $row[0]; ?></option>

 <?php }
 
?> 

</select>
 
<br />

<div id="txtHint"><b>Person info will be listed here.</b></div>

<select name="TR_District" id="TR_District">

<?php
 
$sql="SELECT district FROM statedistrict WHERE state = '".$q."'";
 
$result = mysql_query($sql);
 
while($row = mysql_fetch_array($result))

  {

  ?>

 <option value="<?php echo $row[0]; ?>"><?php echo $row[0]; ?></option>

 <?php }
 
?> 

</select>

</form>

</body>

</html>

Feb 26 '10 #1

Subscribe Post Reply

1998

gits

5,390

Expert Mod 4TB

in your callback function stateChanged() you set the innerHTML of the node txtHint

Expand|Select|Wrap|Line Numbers

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

... this node doesn't contain anything but text and a <br/> tag which is then replaced ... so all other nodes on the page will stay as they are ...

kind regards

Feb 26 '10 #2

kkshansid

232

100+

thanx for ur valuable suggestion it worked

Feb 26 '10 #3

gits

5,390

Expert Mod 4TB

no problem :) glad to hear that you got it working ....

kind regards
gits

Feb 26 '10 #4

Similar topics

new to AJAX -- can you do this?

by: Frances | last post by:

I literally started learning AJAX just last weekend.. I have this page, http://www.francesdelrio.com/ajax/db2.html, where I'm essentially doing what's here,...

Javascript

AJAX, PHP, Mysql simple query example anyone?

by: Ivan Marsh | last post by:

Hey Folks, I'm having a heck of a time wrapping mind around AJAX. Anyone know of a simple, straight-forward example for pulling a simple query from mysql with PHP using AJAX? As I...

Javascript

Ajax Help img src Images in dd.php

by: danxavier | last post by:

I successfuly installed dd.php and sajax.php files. It runs fine, but I would like to link the $items to an image. I called the field in mysql with the link "pic". Any help would be AWESOME!!! I've...

Javascript

Ajax refresh/reload

by: empiresolutions | last post by:

Im using this script, http://www.captain.at/howto-ajax-form-post-get.php, to make an ajax request to php via a drop-down (DD) select. This works fine. Then using this script,...

Javascript

ajax.response max size

by: trpost | last post by:

I am using ajax / php where I am looking up some info from the database and populating a select list dynamically, however I am running into some sort of size limitation with the ajax.response...

PHP

XMLHttpRequest and AJAX for PHP programmers

by: geevaa | last post by:

http://www.phpbuilder.com/columns/kassemi20050606.php3 XMLHttpRequest and AJAX for PHP programmers James Kassemi Introduction: Although the concept isn't entirely new, XMLHttpRequest...

PHP

Ajax & IE

by: UKuser | last post by:

Hi, I'm working on the following code, which works fine in Firefox, but not in IE. The problem is its not posting the variable to my page and I'm thinking its something wrong with the...

Javascript

php and ajax dynamically created select box onchange event

by: Leena P | last post by:

i want to basically take some information for the product and let the user enter the the material required to make this product 1.first page test.php which takes product code and displays...

Javascript

problem in using ajax function

by: shivendravikramsingh | last post by:

hi friends, i m using a ajax function for retrieving some values from a database table,and display the values in required field,my prob is that the ajax function i m using is working f9 once,but if...

Javascript

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

Looking to do Android software development, any suggestions? Is flutter better?

by: nemocccc | last post by:

hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?

General

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++

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

Online Marketing

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

Couldn’t get equations in html when convert word .docx file to html file in C#.

by: conductexam | last post by:

I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and...

C# / C Sharp