问题是我做了2个下拉菜单，一个是类别，另一个是子类别.我希望当我选择颜色然后下拉显示颜色的值时...如果我选择水果，那么另一个将... [英] The problem is that i made 2 dropdowns one is catagory and another is subcatagory . I want that when i select colors then drop down show value of color ...and if i select fruit then another will...

问题描述

$item_catagory=$_GET[''item_catagory''];
		
	 include("dbconnect.php");
     
	  $quer2=mysql_query("SELECT DISTINCT item_catagory FROM add_item order by item_catagory"); 
         

 
 $quer=mysql_query("SELECT DISTINCT name FROM add_item where item_catagory=''$item_catagory''"); 
 		 
     
		   $quer2=mysql_query("SELECT DISTINCT item_catagory,item_id FROM add_item order by item_catagory"); 
		 echo "<select name="item_catagory" onchange="\"><option value="">Select one</option>";


while($noticia2 = mysql_fetch_array($quer2)) { 
if($noticia2[''item_id'']==$cat){echo "<option selected="" value="$noticia2[item_id]">$noticia2[item_catagory]</option>"."<br>";}
else{echo  "<option value="$noticia2[item_id]">$noticia2[item_catagory]</option>";}
}
echo "</br></select>";
 

	echo"  
  
  <tr>
    <td width="131">Select Model</td>
    <td>";
		    

	echo "<select name="subcat"><option value="">Select Model</option>";
while($noticia = mysql_fetch_array($quer)) { 
echo  "<option value="$noticia[name]">$noticia[name]</option>";
}
echo "</select>";
   
	 
	 ?></td></tr>

推荐答案

item_catagory =

item_catagory=

_GET [''item_catagory'']; include("dbconnect.php");

_GET[''item_catagory'']; include("dbconnect.php");

quer2 = mysql_query(从item_catagory的add_item顺序中选择DISTINCT item_catagory");

quer2=mysql_query("SELECT DISTINCT item_catagory FROM add_item order by item_catagory");

这篇关于问题是我做了2个下拉菜单，一个是类别，另一个是子类别.我希望当我选择颜色然后下拉显示颜色的值时...如果我选择水果，那么另一个将...的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！