turn database field on/off

[michaelowen]

hello everybody!

I need some help being able to turn a field in my mysql database on/off.

I am sending info through php forms. What i need to do is have a user send information, and the default value of their info will be "off" (value=0). ONce I verify their information I will change their value to 1, and thus activate the users row.

Can anybody help me do this? Or tell me what this is called.

I apologize if this is a simple question.
Thanks,

-Michael

[zingbats]

Have a read of this:

http://www.phpfreaks.com/tutorials/40/1.php

it explains about verification etc.

Put simply, in you query where it selects the user details, put:

SELECT * from user_table WHERE username = '$form_username' AND password = '$form_password' AND verified = '1'

That way, they can't login until they are verified.

Have a read of http://www.phpfreaks.com/tutorials/40/1.php anyway, coz it is quite interesting