Page 1 of 1

turn field on/off help?

Posted: Fri May 16, 2003 4:35 pm
by speedamp
Hello.

I am wondering what would be the best way to turn a field on/off in my database.

For example, when a new user registers I would like the status of his account to be "off" (value=0), and once validated then I will change the status to "on" (value=1).

I would like the default to be off.

thanks,
-michael

Posted: Fri May 16, 2003 10:40 pm
by evilcoder
well just change the default to off? If your using phpMyAdmin, i cant see why your having problems? Just modify the field, if your doing it manually i suggest going to mysql.com and checking out the "ALTER" statement.