Hi, This is a code of Dynamic Drop Down Option.
If I select Item Code It Shows Item Name and vice versa.
I need to fill option from MySQL Database. Can anybody help me out. please .

<html>
<head>
<title>Gender  Drop Down Test</title>
<script type="text/javascript">
function selectItem(value, id){document.getElementById(id).value=value;}
</script>
</head>
<body>
I'm a 
<select name='item' id='ItemCode' onChange="selectItem(this.value, 'ItemName');">
  <option value='0'></option>

</select>.<br />
<p>
<select name='item' id='ItemName' onChange="selectItem(this.value, 'ItemCode')">
  <option value='0'></option>
  
</select>
</p>
</body>
</html>

Thanks
Ayesha

Hey.
Just guessing here since im not really sure what you want....
So just fill in the blanks from ur DB table.

SELECT {table_column_here} FROM {your_table_name} WHERE {what_you_want}

If you can supply the table details i can help you complete this

<? 
$cres=mysql_query("SELECT * FROM table  ORDER BY id ");
$ccunt=mysql_num_rows($cres);
	echo "<script language=javascript>\n";
	echo "function getsubcats() {\n";
		echo "var d=document.frmaddpro;\n";
		echo "if(d.selcategory.value==0) {\n";
			echo "d.selsubcat.options.length = 0;\n";
			echo "d.selsubcat.options[0]=new Option(\"Select Subcategory\",\"\")\n";
		echo "}\n";
	while($row_cat=mysql_fetch_array($cres,MYSQL_BOTH)){
		echo "if(d.selcategory.value==".$row_cat['id'].") {\n";
				echo "d.selsubcat.length=0;\n";
				$sub_res=mysql_query("SELECT * FROM table WHERE codeid='".$row_cat['id']."'");  
				$i=1;
				echo "d.selsubcat.options[0]=new Option(\"Select Subcategory \",\"\")\n";
				while($sub_row=mysql_fetch_array($sub_res,MYSQL_BOTH)){
					echo "d.selsubcat .options[".$i."]=new Option('".$sub_row['name']."','".$sub_row['c_id']."');\n";
					$i=$i+1;
				}   
		echo "}\n";
	}  
	echo "}</script>\n"; 

?>

<html>
<head>
<title>Gender  Drop Down Test</title>
</head>
<body>
I'm a 
<select name='selcategory' id='selcategory' onChange="return getsubcats();">
  <option value='0'></option>

</select>.<br />
<p>
<select name='selsubcat' id='selsubcat' onChange="selectItem(this.value, 'ItemCode')">
  <option value='0'></option>
  
</select>
</p>
</body>
</html>

i hope this helps

I am using PHP/MySQl
And in my Table there are only 3 fields
Id | ItemCode | ItemName

Please guide me.
Thanks
Ayesha

<? 
$cres=mysql_query("SELECT * FROM table  ORDER BY id ");
$ccunt=mysql_num_rows($cres);
	echo "<script language=javascript>\n";
	echo "function getsubcats() {\n";
		echo "var d=document.frmaddpro;\n";
		echo "if(d.selcategory.value==0) {\n";
			echo "d.selsubcat.options.length = 0;\n";
			echo "d.selsubcat.options[0]=new Option(\"Select Subcategory\",\"\")\n";
		echo "}\n";
	while($row_cat=mysql_fetch_array($cres,MYSQL_BOTH)){
		echo "if(d.selcategory.value==".$row_cat['id'].") {\n";
				echo "d.selsubcat.length=0;\n";
				$sub_res=mysql_query("SELECT * FROM table WHERE codeid='".$row_cat['id']."'");  
				$i=1;
				echo "d.selsubcat.options[0]=new Option(\"Select Subcategory \",\"\")\n";
				while($sub_row=mysql_fetch_array($sub_res,MYSQL_BOTH)){
					echo "d.selsubcat .options[".$i."]=new Option('".$sub_row['name']."','".$sub_row['c_id']."');\n";
					$i=$i+1;
				}   
		echo "}\n";
	}  
	echo "}</script>\n"; 

?>

<html>
<head>
<title>Gender  Drop Down Test</title>
</head>
<body>
I'm a 
<select name='selcategory' id='selcategory' onChange="return getsubcats();">
  <option value='0'></option>

</select>.<br />
<p>
<select name='selsubcat' id='selsubcat' onChange="selectItem(this.value, 'ItemCode')">
  <option value='0'></option>
  
</select>
</p>
</body>
</html>

i hope this helps

My table fields are Id,ItemCode and ItemName
Please I am confused
Please

Thanks for your help.

This question has already been answered. Start a new discussion instead.