filter result in combobox

[Uncoder]

Hi,

$localid = $_GET["id"]; 
<form>
<SELECT name="localid" onchange="reload(this.form)">
                        <OPTION value=0
                          <? if($localid==0) {echo " selected ";}?>>select 
                        <? 
						$country2=mysql_query("select uid from products where datanum='$localid'");
						  $rst6= mysql_fetch_assoc($country2);
						  $namename=$rst6["uid"]; 
						  $country1=mysql_query("select * from members where datanum='$localid' and
						   id !='$namename'");
						  while($rst= mysql_fetch_assoc($country1))
						  {
						  ?>
                        <OPTION value=<? echo $rst["id"];?> <? if($rst["id"]==$userid) {echo " selected ";}?>><? echo $rst["username"];?></OPTION>
                        <?
							   } // wend
							   ?>
                      </SELECT></form>

whats problem in my code?

[Uncoder]

Any Help ????

[Desdinova]

I suggest giving us some more info about the issue that is occuring 🙂 it's no fun looking at your issue now.

[Uncoder]

i have two sql query for filter data in dropdown box ! but with my code only one rows filter in dropdown box! Example :

Table member :
id | name | age | datanum

Table products :
id | uid | name | cat | etc..

Now i want to show user in dropdown box :
if user id was not in table products and = datanum . so show all user where datanum=$userid

Sorry for my bad english.

[Uncoder]

Help please