- Code: Select all
<?php
mysql_connect('localhost', 'root', '');
mysql_select_db('test');
$sql = "select descr from firm order by id";
$records = mysql_query($sql) or die(mysql_error());
echo "<select>";
while($row = mysql_fetch_array($records))
{
echo "<option value='".$row['descr']."'>".$row['descr']."</option>";
}
echo "</select>";
echo "<br>";
mysql_free_result($records);
?>
I want to retrieve the selected value into a variable for further proccessing.
Thank you in advance - Nic