Help with email validation please...

Posted on 16th Feb 2014 07:03 pm by admin

Hi,
Please could you help.
I have a register.php login page where users register, the details are then logged into a temporary database, the user receives an email to verify their email address and then they complete the captha code and their details move to the permanent database. The problem I'm having is the email validation:

//SELECT * FROM $tbl_name WHERE Code = '$passkey'"
$sql="SELECT * FROM $tbl_name WHERE Code = '$passkey'";
$result=mysql_query($sql);


if($result){

$count=mysql_num_rows($result);

if($count==1){

$rows=mysql_fetch_array($result);
$LName=$rows['LName'];
$FName=$rows['FName'];
$UserName=$rows['UserName'];
$Password=$rows['Password'];

The user receives the email and when they try to validate the information the message "wrong confirmation code" appears.

Please help as I've checked this several times and its driving me nuts.

Thanks

Your Answer:

Login to answer

Other forums

Help uploading .JPG
I have a problem with upload images when the ending is .JPG capitalized.. I really don't know what c

Login Functionality Working Different on IE
This is an odd one, I have a site which has an admin section. The admin pages unsurprisingly require

Progress bar tracking file downloads
Hey guys, was wondering if there was a way to track how far a file has been downloaded. I know there

$variable $variables type question
I need to be able to designate an array element dynamically, so I thought to use a variable variable

Where am I going wrong
Been trying to work this out for hours

I have two tables called 'Genres' and 'Films'. Genre

What is SAP Avatar ?
Hi All,

This G.Satish , my boss asked me to explore on SAP Avatar. I searced in internet

Displaying Multidimensional Arrays...about to put my head in a vice, PLEASE HELP
I am fairly new to PHP and MySQL and I have a problem which I have been trying to resolve for days.

Downloading file (Headers)
I'm trying to make users download a file, but they must wait 60 seconds before it begins.

But

login from external site
Hi my new experience begins, Now what i am trying to do is i make three pages, login.php logout.php

Give me all your tricks for minimizing jar file size

Hi, I'm coming close to releasing my J2ME game... I am kicking up against the 64k size barrier w