Help - Insert into MySQL Database Using PHP

Question

I'm trying to allow users to register with the site I am creating, however the code I am using is not working and I need you're help.

$registerquery = mysql_query("INSERT INTO users (Username, Password, EmailAddress) VALUES('".$username."', '".$password."', '".$email."'");

I only want to store the Username, Password and Email Address at this stage.

not working? What is the error you get? use mysql_query('.{your query here}.') or die(mysql_error()); to find out — MrSoundless
– MrSoundless, Commented Aug 4, 2010 at 23:24
post what happen when you use the above code, errors, anything ? Also make sure to use php.net/manual/en/function.mysql-real-escape-string.php so you can filter the data being added to your database instead of falling to the injection abuse. — Prix
– Prix, Commented Aug 4, 2010 at 23:26

LizB · Accepted Answer · 2010-08-04 23:23:50Z

7

You're missing a ) at the end of the query.

$registerquery = mysql_query("INSERT INTO users (Username, Password, EmailAddress) VALUES('".$username."', '".$password."', '".$email."')");

answered Aug 4, 2010 at 23:23

LizB

2,21317 silver badges17 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

john010117 · Accepted Answer · 2010-08-04 23:23:29Z

0

$registerquery = mysql_query("INSERT INTO `users` (`Username`, `Password`, `EmailAddress`) VALUES ('".$username."', '".$password."', '".$email."')");

answered Aug 4, 2010 at 23:23

john010117

2011 silver badge3 bronze badges

Stephen RC · Accepted Answer · 2010-08-04 23:27:43Z

0

You are missing the closing bracket in your SQL query. Try this line:

$registerquery = mysql_query("INSERT INTO users (Username, Password, EmailAddress) VALUES('".$username."', '".$password."', '".$email."')");

Note the ) at the end: "')");

answered Aug 4, 2010 at 23:27

Stephen RC

1,5042 gold badges19 silver badges36 bronze badges