Jump to content

a registration page


mistakes!

Recommended Posts

hello i am trying to write a registration code but when i feel in the form i get this message
Your email entry already exists..so please register again.


$queryq = "insert into registered values('$flag','$firstname','$lastname','$dateofbirth','$email','$password','$companyname','$street','$country','$phone','$fax','$area')";
$resultq = mysql_query($queryq) or die("Your email entry already exists..so please register again..");
$sub="Registration";

pls any ideas will be highly appreciated.
Link to comment
Share on other sites

change this:

$resultq = mysql_query($queryq) or die("Your email entry already exists..so please register again..");

to this:

$resultq = mysql_query($queryq) or die(mysql_error());

and it will give you a hint to fix it. if you still can't fix it then ask again.

hint: insert into table (column1, column2, etc...) values (value1,volumn2, etc..)
Link to comment
Share on other sites

hello thks alot for all your help i was able to solve the problem...one last question on registration the code is meant to send an auto email to the registrant and it is not doing that. where have i gone wrong?
$queryq = "insert into registrant values
('$flag','$firstname','$lastname','$dateofbirth','$email','$password','$companyname','$street','$country','$phone','$fax','$area')";
$resultq = mysql_query($queryq) or die("Error with the query. Message: ".mysql_error());
print mysql_error();
$sub="Registration";
$message="You have been registered has an author with id $flag";
mail($email,$sub,$message,'From : admin');

echo ' You have been sign-up successfully ';
Link to comment
Share on other sites

This thread is more than a year old. Please don't revive it unless you have something important to add.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.