I am getting an error when I am trying to insert data into my db.
I posted a question similar to this in the coding help forum I was trying to retrieve data and somone replied saying that there was no data. So i looked further into this and I found that the inserting command wasnt working. Below I have included the error, the php coding that I am using to insert and the versions of mysql and php. Any help would be great. Thanks
Here is the error that appears on the page
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 '" VALUES (due_date="2003-08-21", inserted="2003-08-21", pri
Here is my php coding
$Insert = mysql_query("INSERT INTO $Table_tasks SET due_date=\"$Ddate\", inserted=\"$Mdate\", priority=\"$priority\", title=\"$title\", task=\"$task\", completed=\"0\", email=\"$email\"") or die(mysql_error());
Here are the versions I am running
PHP 4.3.2
MYSQL 4.0.14b