Hello all,
I'm trying to set up an add contacts page but when I click submit then check the database there is nothing there. I ran my sql query in phpMyadmin and got an error but for the life of me I cannot figure out what is wrong.
I can display the dummy data I inserted but it's the INSERT that is the issue.
Any help much appreciated.
Error
SQL query:
(
"INSERT INTO `greentech_leads` VALUES (' ', '$name', '$address', '$website', $contact_name', '$job_title', '$email', '$tel', '$notes', '$follow_up', '$greentech_contact' ) "
) OR die(
mysql_error(
)
);
MySQL said:
#1064 - 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 '"INSERT INTO `greentech_leads` VALUES (' ', '$name', '$address', '$website', $co' at line 1