Member Avatar for ayesha789

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

  • 4 Contributors
  • 11 Replies
  • 132 Views
  • 3 Days Discussion Span
  • Latest Post Latest Post by ayesha789
Member Avatar for cybrax

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

Member Avatar for cybrax

Are you using any server side scripting...
Please give some more info

Member Avatar for praveen_dusari 
<? 
$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

Member Avatar for ayesha789

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

Please guide me.
Thanks
Ayesha

Member Avatar for ayesha789

Praveen what is id?
is it my Database Table id?

Member Avatar for praveen_dusari

yes its your database table id

Member Avatar for ayesha789 
<? 
$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.

Member Avatar for ayesha789

Please give some comments about the code.

Thansk
Ayesha

Member Avatar for praveen_dusari

find the attachment and if you have any other doubts let me know

subcat.zip (1.97 KB)
Member Avatar for somedude3488

Why not use ajax? Its better than having php create the javascript which adds to the page size and load time.

Member Avatar for ayesha789

How?
Please guide.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.