How do I set a default value for ENUM fields in PHP?

You do this the same way as you would set a default for any field, here is what you need to write in your code for the field definition when creating your table:

myfieldname ENUM('option1','option2') default 'option2'

Comment on this Question and Answer >>>

ASK A QUESTION

More mysql PHP Questions

How do I connect to mySQL from PHP?

How do I find second highest value from a table?

I am unable to make pages for my search result.Below I am giving the code that I am using. Career Search result Yami says

What is difference between mysql_fetch_array and mysql_fetch_object?

How do I update the contents of a table row?