连接到版本5.0 mysql时当前语法错误

Question

I am really having a tough time understanding what syntax to use. I am VERY green when it comes to coding. I copied this code from another website that is working just fine but they are hooked up to a 4.3 version of mysql- can anyone help?This is the error-

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 '1, city, state, zip, ) VALUES ('', , ' 1', '', '', '','' )' at line 1

Here is my code:

mysql_select_db("membership70", $con);  

$name=mysql_real_escape_string($_POST['Name']); 
$address1=mysql_real_escape_string($_POST['Address1']); 
$city=mysql_real_escape_string($_POST['city']); 
$state=mysql_real_escape_string($_POST['state']); 
$zip=mysql_real_escape_string($_POST['zip']);
$email=mysql_real_escape_string($_POST['email']);

$sql="INSERT INTO Members (name, email, adress 1, city, state, zip, ) VALUES ('$name', , '$address 1', '$city', '$state', '$zip','$email' )"; 

if (!mysql_query($sql,$con)) {
  die('Error: ' . mysql_error());
}

Answer 1

Get rid of the space in adress 1 and your variable $adress 1....not allowed (spaces that is)