php - You have an error in your SQL syntax - near 'left) -
i'm newbie in php programming.
i apply insert query error :
you have error in sql syntax; check manual corresponds mysql server version right syntax use near 'left) values ('****df','****2135gh','***@yahoo.com' @ line 2"}
$sql_insert_new_user = "insert users (username,password,email,status,finance,province,city,address,tell, mobile,admin_seen,type,left) values ('$username','$password','$email',1,0,$town,$city, '$address','$telephone','$mobile',0,'employe',0)"; mysql_query($sql_insert_new_user); $error = mysql_error();
left
reserved word , in query need escape backtics
`left`
Comments
Post a Comment