hi, im fetching options for a drop down box from a database which is all working appropriately. i have implemented an admin section where you can update each player's information in the database for a football website. my question is when the update for a member is selected i want the drop down box to select the value that is already stored from the database.
for example a member can have a player position i.e. gk/def/mf/amf/str
i want the option that has previosly been chosen and stored in the database to be selected as default when the update profile of that player is loaded. currently it defaults to the first value and if you dont change again each time, you end up i.e. with gk for a striker. its easy to alter just annoying if you forget and would be much better if this is implemented. i also need it for other things like match reports, i.e. venue - home/away/neutral.
and one additional question, how do you make a drop down box auto goto a page when the value is selected opposed to having a button that directs to the page, this is also from fetching the values from a database.
thanks in advance