You use the $_POST array variable in your form handling routine to get the select value, namely $_POST['color'] in your case. Once you get this, simply use it in your update/insert SQL query.
Reputation Points: 1046
Solved Threads: 942
Sarcastic Poster
Offline 6,661 posts
since Oct 2006