Automatically selecting a value in a drop down field from the MYSQL value
I'm pretty new to PHP/MYSQL. I have a customer database which has numerous drop down fields when adding a new customer. I made these drop down fields as normal HTML drop downs instead of arrays. The problem I am having is when we edit a customer. The customer fields used to be text boxes and I just had value="<?php echo $name; ?>" in each field for editing. I do not know how to have the script automatically select the value from the database in the drop down field. Any ideas?