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

iterating through an array and escape each value independently.
I have a set up where the variable being escaped is an array and it needs to be iterated and escaped

Referential Integrity problem when inserting into 2 tables at same time
Hello Everyone,

Im relativity new to PHP and MySQL and i have come up against a problem. i h

Passing JS to PHP
So I have the following
Code: <?php
getdetails(?><script type="text/

Shuffle Array
Hi,

I am writing a script for a game that needs players to randomly be assigned a target (ano

Good Programming and Web Design Books
Hi,

I recived a pm today from a fellow phpfreaker regarding php books, i replied with the fo

how to query data from website using VC?
I want to query some datum from a website,so I need a program to read data from a .csv file, and ass

replacements
I have a variable in my PHP script like

ASSFDDDDDDDDDDDDDASDDDDDDDDARYTRHKKHHHHHHHHHHH and p

an interesting question
Greetings folks, got to ask an interesting question...

let say
i have created a function s

Save cookie to DB
I'm working on a pixel tracking script for an incentive website and I need to use an ASP script to s

simple ping code
been searchin the site/web and found code thats simple but doesnt work.

I have a personal we