I was working with php and mysql and can't seem to insert data into a database. Here's the error below:
Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'My Street','A00 1PQ','')' at line 3
$username = mysql_real_escape_string($_POST['username']);
$pword = mysql_real_escape_string($_POST['passwd']);
$fname = mysql_real_escape_string($_POST['firstname']);
$lname = mysql_real_escape_string($_POST['lastname']);
$email = mysql_real_escape_string($_POST['email']);
$telephone = mysql_real_escape_string($_POST['telephone']);
$ad1 = mysql_real_escape_string($_POST['ad1']);
$ad2 = mysql_real_escape_string($_POST['street']);
$ad3 = mysql_real_escape_string($_POST['town']);
$pcode = mysql_real_escape_string($_POST['pcode']);
$con = mysql_connect("localhost","myuser","mypass");
if (!$con)
{
die('Could not connect: ' . mysql_error());
}
mysql_select_db("peoplesdb", $con);
//$description = mysql_real_escape_string($_POST[description]);
$sql="INSERT INTO members (username, pword, fname, lname, email, telephone, ad1, ad2, ad3, pcode, status)
VALUES
('$username','$pword','$fname', '$lname', '$email','$telephone','$ad1','$ad2,'$ad3','$pcode')";
The data on that line 3 are address3 and post code. Everything seem ok to me, but still can't figure out what might be the problem.