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).
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.