Forum Moderators: coopster

Message Too Old, No Replies

Default Value

On PhpMyAdmin

         

Ultra101

8:20 pm on Mar 26, 2009 (gmt 0)

10+ Year Member



Okay, this is probably a relatively simple thing to do, but simple is hard for me. :D

Well, I'm making a site and all, with Registration, and when people Register I want it to Record their Position. [Admin, Mod...]

Now, when I do it as 'Enum.' or 'Set' it doesn't work. I have it like this:

Field: Position
Length/Values: 'Member'
NULL: Not NULL
Default: Member

That's how I have it set up, yet when I test it, that Position Field is blank.

omoutop

3:27 pm on Mar 27, 2009 (gmt 0)

WebmasterWorld Senior Member 10+ Year Member Top Contributors Of The Month



if you set it to set/enum, enclose all possible values in single quotes and seperate them with commas.

Example for type set: 'Y','N'