INVISIBLE POSTING!!!

[Pavlos1316]

Here is my code:

 

//Connect to database

mysql_connect ($dbhost, $dbuser, $dbpass)or die("Error: " .mysql_error());

mysql_select_db($dbname) or die(mysql_error());

$Full_Name=$_Post['Full_Name'];

$Birthday=$_Post['Birthday'];

$Phone_No=$_Post['Phone_No'];

$E_mail=$_Post['E_mail'];$

Mail=$_Post['Mail'];

$Username=$_Post['Username'];

$Password=$_Post['Password'];

 

$checkuser=mysql_query("SELECT Username FROM Register WHERE Username='$Username'");

$Username_exist=mysql_num_rows($checkuser);

if($Username_exist>0){

echo "Username Already Registered!";

unset($Username);

include 'register.html';

exit();

}

 

$query="INSERT INTO Register (ID, Full_Name, Birthday, Phone_No, E_mail, Mail, Username, Password) VALUES ('NULL','$Full_Name','$Birthday','$Phone_No','$E_m ail','$Mail_Adrdress','$Username','$Password')";

 

mysql_query($query) or die(mysql_error());mysql_close();

echo "Registration Successful!";

 

OK here is the problem.

 

When I test my registration form for 1st time I get: Registration successful. But in mysql db (throught control panel) I have only blank fields exept for ID field.

 

Then when I try my form for second or third time and so on I always get: Username allready registered!!!!!

 

Have you anything to suggest? Where is the problem?

 

Thank you

[burnside]

just looking through your code there several errors i can see,

 

biggest being you have deffined :

$Mail = $_POST['Mail'];

 

But in your insert code you have :

 

$Mail_Addresses,

 

So change either one and it should work.

[Pavlos1316]

Hi

 

sorry about that. I had renamed everything after I tried my db and I missed that.

 

But the results are the same.

 

Blank db exept ID field for first user

 

and all other entries returns username already registered!!

 

Thanks