Im having an error inputting to a database, very simple error i assume but i cant seem to fix it (Even when i copy and paste a query from another page which i am POSITIVE works, ive even used phpmyadminl to generate code for me which worked but not inserting my variable)
$desc = " ".$mons." defeats ".$name." in defence"; $sql9 = mysql_query("INSERT INTO journal(desc) VALUES('$desc')")or die(mysql_error());
The table has two rows, ID which is set to auto_increment, and desc, which is set to text.
i get the following error 10/10 times -
u have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near...
after 'near' it shows the data that should be appended to $desc, and sent, but nothing is, sigh, any help?