Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

› WebAssist Forums › General / Announcements › PHP and MySQL › PHP MyAdmin Default value not showing up in Database

PHP MyAdmin Default value not showing up in Database

Thread began 11/16/2009 1:38 pm by ijk76319396 | Last modified 11/17/2009 2:44 pm by Eric Mittman | 1660 views | 1 replies |

11/16/2009 1:38 pm | #1 ijk76319396

PHP MyAdmin Default value not showing up in Database

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?

11/17/2009 2:44 pm | #2 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.

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now. Build a store, a gallery, or a web-based email solution.