php while looping in combo box

[jaiffed]

i have this script and i am not able to understand what's wrong in this it's not displaying proper in combo box

<?php


   include('connect.php');

   $Tb = "issue";

   mysql_select_db($Db, $link);

   $query = "select DISTINCT mem_id from issue WHERE avail='1' order by issue_id";

   $result= mysql_query($query,$link);

   $nro=mysql_num_rows($result);

while ($row=mysql_fetch_array($result))

{

$mem_id=$row['mem_id'];

$query2 = "select mem_id,mem_name from mem_master WHERE mem_id='$mem_id' order by mem_id";

$results=mysql_query($query2,$link);

$nro=mysql_num_rows($results);

   if ($nro>0)

   {

  echo "<select name='itemissue'>\n";

  echo "<option>-- Select Member ID or Member Name --</option>\n";

  while ($rows=mysql_fetch_array($results))

  {
        //$row[mem_id];
        echo "<option value='$rows[mem_id]'>$rows[mem_id]--$rows[mem_name]</option>\n";

  }


   }


}   
   mysql_close($link);

   ?>

please help me

[djjjozsi]

use the basis MYSQL troubleshooting technique:

mysql_query()  OR DIE( mysql_error());

Echo out your SQL queries, and test in phpmyadmin.
If you're eembedding arrays into a string, use the courly brackets around these values, like:

            echo "<option value='{$rows["mem_id"]}'>{$rows["mem_id"]}--{$rows["mem_name"]}</option>\n";

Inside your while cycles, print out your $row and $rows arrays.

print_r($row);

Lastly, mysql_fetch_assoc() is a better choice becouse mysql_fetch_array() contains your data as doubled associated and numerical arrays available, then you're just waste the resources only.