Am trying to develop a login/registration system so the user must activate its account. My problem is how to check in the database for the column 'activate' which is 0 if it's not activate and 1 if his/her account is active, plus i want to put an if it's not active to display a message.
$sql2 = "SELECT * WHERE username2='$username2' AND activation=0";
$result2 = mysql_query($sql2);
if($result2=1){
echo"Please activate your account";
}
else{
echo " ";
}
Try this :
I hope this helps .