dependent multiple list menu

[amel86]

Hello,
I have a problem. I need to do multiple list menu which is populate each other when selected.
The problem is my code run perfect on my localhost server but when i upload to the server the code seem not too worked. it not update the result.

For example if i select category A it should list out sub category A that is A1 and A2. But, the result is it list out A1, A2 and A3 even i already remove A3 subcategory. So, for me it not update the result. Please help me how to modify this code so that it can run smoothly on the server.

<script>
function getXMLHTTP() { //fuction to return the xml http object
		var xmlhttp=false;	
		try{
			xmlhttp=new XMLHttpRequest();
		}
		catch(e)	{		
			try{			
				xmlhttp= new ActiveXObject("Microsoft.XMLHTTP");
			}
			catch(e){
				try{
				xmlhttp = new ActiveXObject("Msxml2.XMLHTTP");
				}
				catch(e1){
					xmlhttp=false;
				}
			}
		}
		 	
		return xmlhttp;
	}
	function getmodel(strURL) {		
		
		var req = getXMLHTTP();
		
		if (req) {
			
			req.onreadystatechange = function() {
				if (req.readyState == 4) {
					// only if "OK"
					if (req.status == 200) {						
						document.getElementById('modeldiv').innerHTML=req.responseText;						
					} else {
						alert("There was a problem while using XMLHTTP:\n" + req.statusText);
					}
				}				
			}			
			req.open("GET", strURL, true);
			req.send(null);
		}				
	}
</script> 


<form name="testform" action="insert_product.php" method="post" enctype="multipart/form-data" onsubmit="return checkform(this);"> 

<select name="category" onChange="getmodel('populate.php?category='+this.value)">
        <option value='-1'>Select Category</option>
        <?
        $q=mysql_query("select * from category where main_category_id = '1' ORDER BY category ASC ");
        while($n=mysql_fetch_array($q)){
        echo "<option value=$n[category_id]>$n[category]</option>";
        }
        ?>
        </select>


<div id="modeldiv">
        <select name="model">
        <option>Select model</option> 
        </select>
        </div>
</form>



//populate.php code

<? $category=$_REQUEST['category'];
include("db.inc");
mysql_select_db('lenhoe');
$query="select * from model where category_id=$category";
$result=mysql_query($query);

?>
<select name="model">
<option>Select model</option>
<? while($row=mysql_fetch_array($result)) { ?>
<option value="<?=$row['model_id']?>"><?=$row['model']?></option>
<? } ?>
</select>

[dlite922]

If your program runs on one machine, but not another, then it's not a problem with your code but with the server and/or configuration differences between the machines.



Dan