Passing the selected value form a dropdown list from a database

[sandhya]

Id like to load a drop down list from a mysql database and i did it. But that selected value is not passing to the next form. Anyone can help me please?

 

[timmy0320]

Did you view the source to make sure the value's were posting correctly?

[sandhya]

ya i'm giving the code i used here.

<select name="empid" >

          <option value="" selected>Select Empolyee ID</option>

  <?php       

        while ($recs = mysql_fetch_array($empids)){

            $id = $recs['id'];

        ?>

            <option value="<? $id ?>"> <? echo $id; ?></option>                 

      <?

            }  // end while

      ?>

 

          </select>

on submitting this form the value passed is the last row of the selection evry time.

[cyrixware]

can you please post here in the drop down list part?

[cyrixware]

<select name="empid" >
<option value="selected">Select Empolyee ID</option>
        <?      
            while ($recs = mysql_fetch_array($empids)){
           // $id = $recs['id'];
        ?>
            <option value="<?=$recs['id']; ?>"> <?=$recs['id'];?></option>                  
        <?
            }  // end while 
        ?>
</select>

 

take note also in this part:

<option value="" selected>Select Empolyee ID</option>

[sandhya]

thanks. its worked.