Re: Receiving Error- Error: user account already exists..

> I keep receiving the following error..( Error: user account already exists..
> ) although I don't have any data in my table. Any help would be appreciated.
> 
> The code follows:
> 
>  
> 
>  
> 
> <?php 
> 
> session_start();
> 
>  
> 
>  
> 
> include ('dbc.php'); 
> 
>  
> 
>  
> 
>  
> 
> if (isset($_POST['Submit']) =='Register')

As Jim already pointed out, if $_POST['Submit'] is set to ANY value this
check will be true. I think you want something like :

if (isset($_POST['Submit']) && $_POST['Submit'] =='Register')

> {
>    if (strlen($_POST['email']) < 5)
>    {
>     die ("Incorrect email. Please enter valid email address..");
>     }
>
>    if (strcmp(isset($_POST['pass1']),isset($_POST['pass2'])) ||
> empty($_POST['pass1']) )
>                 { 
>                 //die ("Password does not match");
>                 die("ERROR: Password does not match or empty..");
>                 }
> 
>                 if (strcmp(md5($_POST['user_code']),$_SESSION['ckey']))
>                 { 
>                                                  die("Invalid code entered.
> Please enter the correct code as shown in the Image");
>                   } 
> 
>                 $rs_duplicates = mysql_query("select id from users where
> user_email='$_POST[email]'");

You should test $rs_duplicates !== false to be sure you have a valid
resource.

Have you tried retrieving the supposed row(s) and var_dump-ing them to
see what it thinks they are? My guess is, you're getting an error
message, which is why there is a row to be counted. You can't use an
array inside a double-quoted string like that, change it to be wrapped
in braces like:

 $rs_duplicates = mysql_query("select id from users where user_email='
{$_POST[email]}'");


--
Niel Archer
niel.archer (at) blueyonder.co.uk


-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php