problem in combo box view

[jaiffed]

what's wrong in this script it's not working

it's showing only one member detail.....

 

<?php

   

 

include('connect.php');

 

$Tb = "issue";

 

mysql_select_db($Db, $link);

 

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

 

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

 

$fel=mysql_num_fields($result);

$nro=mysql_num_rows($result);

   

    while ($row=mysql_fetch_array($result))

   

    {

     

    $mem_id=$row[mem_id];

   

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

 

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

 

    $fel=mysql_num_fields($result);

    $nro=mysql_num_rows($result);

   

 

if ($nro>0)

 

{

 

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

 

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

 

while ($row=mysql_fetch_array($result))

 

{

            $row[mem_id];

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

 

}

 

}

   

    } 

mysql_close($link);

 

  ?>

[LeadingWebDev]

in the second WHILE statement you overwriting $row variable, that actually holds results from first query.

rename to $row2 for example 

 

hope was helpful

[jaiffed]

i tried rows ,row2 but it doesn't work

[sader]

I gues becouse u are reseting some variables when u are looping inside loop

 

look here:

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

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

    $fel=mysql_num_fields($result);
    $nro=mysql_num_rows($result);

should be changes to something like

 

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

 

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

 

    $fel=mysql_num_fields($result2); //<== do U use this somewhere?

    $nro=mysql_num_rows($result2);

 

then inner while loop should louok like so

     while ($row2=mysql_fetch_array($result2))

      {
            //$row[mem_id]; I think u dont need this at all
         echo "<option value='$row2[mem_id]'>$row2[mem_id]--$row2[mem_name]</option>\n";

      }

 

I am not 100% sure this will solve problem, but this is my first gues

[LeadingWebDev]

also try renaming $query inside loop and $result inside loop.

u overide all vars that u need to use inside a loop.

<?php
     

   include('connect.php');

   $Tb = "issue";

   mysql_select_db($Db, $link);

   $query = "select 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";

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

    $nro=mysql_num_rows($result);
   
   if ($nro>0)

   {

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

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

      while ($row2=mysql_fetch_array($result))

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

      }

   }
    
    }   
   mysql_close($link);

   ?>

 

should work.

...smoking.

[jaiffed]

somehow it works

 

it makes 8 combo box because  rows

[jaiffed]

somehow it works

 

it makes 8 combo box because  rows was also 8

[LeadingWebDev]

alright, put the <select> before the loops and </select> after loops, inside loops leave just <option value="">

then u will get 1 drop down with 8 rows inside.

 

hope was helpful.

[jaiffed]

sorry i had posted twice and that's for sader))))))))

 

thanks you very much LeadingWebDev

your previous script is working

but now this script have a problem it's not picking mem_name value

[sader]

are u fetching $result2 in inner while loop?

[LeadingWebDev]

while ($row2=mysql_fetch_array($result2))

 

      {

//$row[mem_id];

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

 

      }

 

totally fixed 

[jaiffed]

its working perfectly

 

thanks you both of you

 

and sincerely thanks to  Leading Web Dev.

 

thankss