Populate HTML Form Dropdown from DB 1

[WilliamMute]

Hi all,

Can anyone please help towards how I can populate an HTML dropdown option list with values from a table column in my MYSQL DB using PHP please.

Any help appreciated.

Thank you

 

[jpadie]

something like this

//run the query
$result = mysql_query("Select description, value from table");
//start the select box
echo '<select name="select">';
while ($row=mysql_fetch_assoc($result)){
//iterate through outputting options
echo '<option value="'.$row['value'].'">'.$row['description'].'</option>';
}
//close the select box
echo '</select>';

 

[WilliamMute]

Simply Genius. Thanks once again jpadie. Works perfect. I have been getting a full page coding from different website I've been visit, so complex its unbeleivable and yours is just a few lines of straight forward codes.

'Simply the best'