mysql数据库选择option,在MySQL数据库，PHP中存储下拉选项

I need to store the user selected option when chosen from my drop down select box, and when submitted in my form, store in my MYSQL database.

I already have information being stored and displayed fine, i am just trying to add more content now. I have tried using the same method, but i cant get it to store what i want.

The select drop down looks like this inside my form:

Difficulty:

easy

comfortable

hard

very hard

Hardest ride in the world!

and i am trying to send it using this:

$difficulty = mysql_real_escape_string($_POST['difficulty']);

Using this query:

$query = sprintf("INSERT INTO markers (difficulty) VALUES ('%s')", $difficulty);

When my table is set up as INT, 20, allow null, it stores 0 in the database.

and when i set it up VARCHAR, 20, allow null, it stores a blank field.

i want it to store whichever value the user chooses, i.e easy, hard, very hard etc.

Thanks very much

解决方案

$_POST['difficulty']

Would not hold a value as the SELECT has not been given a 'name'. Try