swisse

Hi uncfelt1147, I'm no expert in PHP, just like you I'm a newbie. I find your query statement a little bit long with all those \n's. This is the code from Larry's book: $q = "UPDATE users SET active=NULL WHERE (email='" . mysqli_real_escape_string($dbc, $_GET['x']) . "' AND active='" .mysqli_real_escape_string($dbc, $_GET['y']) . "') LIMIT 1"; I check always with phpMyAdmin that the person I'm activating is recorded in my database.

I don't know what the cause was, but I think I lost the contents of x and y while being processed in activate.php. Therefore I assigned x and y to variables and the activation went through. Thanks Larry for helping me.

Hi Larry, The URL http://usereg/ brings me to the index.php.

Hi Larry, This is the message with a new link: Thank you for registering. To activate your account, please click on the link: http://usereg/activate.php?x=aylilynandrizzo%40gmail.com&y=972205c63d7503b9c9ebdfbb6a63de40 Thanks.

Thanks Larry for the fast reply. Sorry for the error, I wasn't sure if it was 1 r or 2 r's. You're right. I checked the name of the virtual host and it contains only 1 r. So it's named usereg. My apologies. If I click the link in my email it still says "Not Found The requested URL/$url was not found on this server".

Hi everybody, I'm new to PHP. Please help me out with my problem. I'm developing my site in a virtual host on a Mac OS Lion with MAMP Pro. I can send emails to my dummy email address: Thank you for registering. To activate your account, please click on the link: http://userreg/activate.php?x=sampleemail%40gmail.com&y=23478180b400db193c28e328f1edd8c1 but can't activate the user because of this error: Not Found The requested URL /$url was not found on this server. Thanks for taking your time to read my post.