php populate drop down list from MySQL

[accelerator]

Tweet

Hi All

Can anyone provide a link for a decent tutorial to do the following php task:

I want to populate a drop down list from my list of merchants in a MySQL database. The Merchant Name will be visible to the user, and the Merchant Id will be the value that is selected.

Thanks for any help.

[Donk]

Connect to database etc
<form>
<select>

<?php 
$sql="SELECT id,name FROM merchants";
$result =mysql_query($sql);
while ($data=mysql_fetch_assoc($result)){
?>
<option value ="<?php echo $data['id'] ?>" ><?php echo $data['name'] ?></option>
<?php } ?>

</select>
</form>