I have a drop down list that is being populated by a MySQL db table, I am trying to display the information and want to have the drop down list populated with the user's choice selected with the rest of the list. Please help. Thanks

JE

 drop down list populated by a MySQL db table


<?php require_once('Connections/test.php'); ?>



<?php
mysql_select_db($database_test, $test);
$query_Recordset1 = "SELECT * FROM tour_data";
$Recordset1 = mysql_query($query_Recordset1, $test) or die(mysql_error());
$row_Recordset1 = mysql_fetch_assoc($Recordset1);
$totalRows_Recordset1 = mysql_num_rows($Recordset1);
?>







<form name="form1" method="post" action="">
    <label>
      <select name="select">
        <?php
do {
?>
        <option value="<?php echo $row_Recordset1['tour_title']?>"<?php if (!(strcmp($row_Recordset1['tour_title'], "3"))) {echo "selected=\"selected\"";} ?>><?php echo $row_Recordset1['tour_title']?></option>
        <?php
} while ($row_Recordset1 = mysql_fetch_assoc($Recordset1));
  $rows = mysql_num_rows($Recordset1);
  if($rows > 0) {
      mysql_data_seek($Recordset1, 0);
      $row_Recordset1 = mysql_fetch_assoc($Recordset1);
  }
?>
    </select>
    </label>
  </form>

Escaler