php/mySQL and html <select>

hi... I have a user registration system that I need to add a "state" field to. Part of the form will look something like this but with all 50 states instead of just two: <form> <select name="state"> <option value="AK">AK</option> <option value="AL">AL</option> </select> </form> ...how do I insert the user's state into the database and then how do I show the user's state as the "selected" state in the drop down list later when the user comes back to update his/her profile? hope this makes sense.. thanks, nick __________________________________________________ Do You Yahoo!? Yahoo! Auctions - buy the things you want at great prices http://auctions.yahoo.com/