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

retrieving images from mysql database using php
So I've been trying to figure out how to store images in a mysql database, and as far as i can tell

Passing variables with pagination - iterating through unique id per link
Hi everyone,
I have seen a few topics like this one. Still cant find the specific thing, so I am

Header is not working in IE
Hi ! header function is not working in IE but it works in FF, Safari, Chrome. any help please. :

Error querying database.
I get the above error when trying to insert some values to a datatable.
Here's the code :

Greek characters in php
Hi,

I'm making a script and I m using for first time greek characters.
I started to write

Convert .fdf to .pdf
I currently have a web form that uploads the form data to an .fdf file and emails it.

However

Why use interfaces in PHP (OOP)
I am learning OOP in PHP and its been a pretty good learning experience so far. What I didn't unders

Chat Box in PHP
I was thinking in doing a Chat Box in PHP. For that I would use a form with two fields, Nick and Mes

DOMDocument
Hello All,

I need to take an XML document, modify some of the nodes in it and then perform a

Simple Scraper... Weird Output
Okay, maybe I just need a Blue Monster and some sleep, but....

I'm scraping a ringtone site