Hi i am working on php and mysql.

I have a form where in i am accessing data from one table and upon selection i am inserting that data in to another table. But my major constraint is the selected data id is being stored instead of the data value.

kindly let me know how to get the data value instead of the data id.

Below is the sample code.

```
<td>Status:</td>
                    <td>   <select name="status" id="status">
          <?php $svar = mysql_query("select * from status");
          while($sresult = mysql_fetch_array($svar)){ ?>
          <option value="<?php echo $sresult['id']; ?>" <?php if($sresult['id']==$row['status']){ echo "selected"; }?> /><?php  echo $sresult['status']; ?></option>
          <?php } ?>
                        </select> </td>

```

Now i am inserting the data from the above form in to another database using the following query:

```
$sql="INSERT INTO Createticket (......,status) VALUES(..........,'$status')";

```