I'm trying to write somthing to verify a users email address before setting the 'active' column in a database. I've been looking at the tutorial here 'http://net.tutsplus.com/tutorials/php/how-to-implement-email-verification-for-new-members/' but my problem is that when I get the email and hash from the url it looks like this:
so when I compare it to my database email it doesn't match - since the database email is:
I would've thought this would still match using
but it doesn't.. I tried using one equals sign but it just returns 1 for any email address in the database :S
if($_REQUEST['email'] == $row['email'])
I also tried just looking at mysql_num_rows like this:
but it still doesn't work... In the tutorial I notice he calls variables from the url just by using $email and not $_GET['email'] or $_REQUEST['email'] but when I tried that it returns blank.. wtf?
$check = mysql_query("SELECT email, hash, active FROM users WHERE email='".$_REQUEST['email']."' AND hash = '".$_REQUEST['hash']."' AND active = '0'") or die('Sorry, a mysql error occured');
$result = mysql_num_rows($check);
Please help me, I feel like I'm ready to stab someone.