[SOLVED] Boolean Help

[Rifts]

I'm just php and mysql. I can not figure this out...

 

When someone signs up for my website I want a hidden boolean value to be set as 0 in my table in my database and upon doing something specific it will change the value to a 1.

 

how can I do this?

 

Thanks

[abazoskib]

alter the column to have a default value of 0..ex.

 

alter table mytable change mycolumn enum('0','1') default 0;

[Rifts]

i have made a little form so when i enter in an email it will change that account from a 0 to a 1

 

why is this not working

 

//Create query

$qry="UPDATE members SET active = '1'

WHERE email='$email'";

$result=mysql_query($qry);

[Rifts]

nvm figuered it out