Code: Select all
----------------
id| type | cost
----------------
1 | reg | 500
2 | exp | 600
----------------
Code: Select all
<?
include "conf.php";
echo "<p>Cost <select city=name id=name>";
$cost = "SELECT type,cost from destination";
$reqcost = mysql_query($city) or die ("Error!");
while($result=mysql_fetch_array($reqcost))
{
echo "<option value=$result[type]>$result[type]</option>";
}
echo "</select>";
?>
Also, I want to display one row from database inside the option list,
Code: Select all
| reg | 500