turn field on/off help?

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
speedamp
Forum Commoner
Posts: 45
Joined: Tue Apr 29, 2003 3:59 pm

turn field on/off help?

Post 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
evilcoder
Forum Contributor
Posts: 345
Joined: Tue Dec 17, 2002 5:37 am
Location: Sydney, Australia

Post 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.
Post Reply