Rifts Posted November 5, 2009 Share Posted November 5, 2009 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 Link to comment https://forums.phpfreaks.com/topic/180438-solved-boolean-help/ Share on other sites More sharing options...
abazoskib Posted November 5, 2009 Share Posted November 5, 2009 alter the column to have a default value of 0..ex. alter table mytable change mycolumn enum('0','1') default 0; Link to comment https://forums.phpfreaks.com/topic/180438-solved-boolean-help/#findComment-951924 Share on other sites More sharing options...
Rifts Posted November 5, 2009 Author Share Posted November 5, 2009 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); Link to comment https://forums.phpfreaks.com/topic/180438-solved-boolean-help/#findComment-951974 Share on other sites More sharing options...
Rifts Posted November 5, 2009 Author Share Posted November 5, 2009 nvm figuered it out Link to comment https://forums.phpfreaks.com/topic/180438-solved-boolean-help/#findComment-951977 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.