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

Limiting uploaded file type
I am working on a simple upload script, and I need it to limit the allowed file type that is uploade

i need help with php header and footer
I have designed a header and footer for my site and they seem to be ok when they are running individ

Preserving user-entered linebreaks
Hi, I'm building a web 2.0 thingy from scratch and I wanna display text which users input. It's all

chat
hello i'm amir i need a chat source code in asp.net 2.0 without Ajax. anybody can help me?

Please help with code for SMTP authenticated PHP email form
Hello, I'm creating a PHP email form, and for this particular server, I have to use SMTP Authenticat

Xml parsing
I need a suggestion about parsing xml with multiply parts like pervious...
i.e. different device

array_diff weirdness
I'm using the following bit of code

$diff = array_diff($pids, $pidlist);
$diff = array_va

Two fgetcsv related questions ;D
First of im trying to get a file from a merchants server but the directory is protected, I know the

RadioButtonList data selection
view plaincopy to clipboardprint?

cPanel API
Hi Guys,

Need a little guidance. I'm trying to get my script to communicate with cPanel (or W