MySQL data to popup menu

[ashz]

Hi,

How can I create a popup select menu inside HTML that is content is dynamic (MYSQL field data). And how can I read the variable and use it.

Thanks.

[Oleg Butuzov]

Code: Select all

$query=mysql_query("SELECT id, caption FROM `location`");


echo"<form method=post action=pejone.php>  <select name=popupmenu size=1>";

while ($data=mysql_fetch_aray($query))
{
echo"    <option value=$data['id']>$data['caption']</option>";
}
echo " </select></form>";