(HELP!!) how to populate option values ?

[mungra]

Hi !!

Well my aim is to dynamically fill option value from a recordset

//connection stuff

$result = mysql_query($myquery);

<select name="test" size =1 id="myselect">
<option value ="1">one</option>

<?php

// need some codes here to dynamically assign
// the option values from the recordset array $result
?>

help plz
regards

[TobyRT]

All you need to do is put a while loop (or a foreach?) around the resulting array $result. In may case $result is called $mem_country

$mem_country = $connector->query("SELECT * FROM mem_country")or die ("Error in Query: $query.".mysql_error())

echo '<select name="country"><option selected>Select your Country</option>';

while ($row = mysql_fetch_array($mem_country))
{
echo '<option value="'.$row['mem_country_id'].'">'.$row['mem_country_name'].'</option>';
}
echo '</select>';