PHP MyAdmin Default value not showing up in Database

[ijk76319396]

I have a default value for a table and it's not showing up. If a guest submits a comment on my page I want the default to read guest. If they are logged in it shows there username is automatically entered and this works fine. For some reason the default is not working that I have entered for PHP myAdmin on the specific table. Below are the values.

The field name - USER_NAMES
TYPE -VARCHAR (55)
Coallition- Latin/Swedish
Attributes- Blank
Null- No
Default- Guest
Extra- Blank

What am I missing here?

[Eric Mittman]

If you just have this entered as Guest it will probably not work. You should make sure to put this in double quotes so it is treated as a string like this:

"Guest"

I did a test of this both ways in my db and having it in the double quotes made it work.