Hi,
I have any dropdown box(combobox) for retrieve data ! this dropdown box list user for each user id. now when i filter result my code not work! my database is :
member :
id | name | age | datanum
products :
id | uid | name | cat | datanum |etc..
i want to show name of member column when datanum = $localid and uid was not in products.
<?php
$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["name"];?></OPTION>
<?
} // wend
?>
</SELECT></form>
Thanks For Any Help