Killing Me!!!!

Ryan_Sanders

$sql = mysql_query("INSERT INTO d_files (name, desc, url, ss, author, cid, sid) VALUES ('$name', '$desc', '$url', '$ss', '$author', '$cid', '$sid')") or die(mysql_error());

Ok, I am using that to add to database.. but I keep getting this 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 'desc, url, ss, author, cid, sid) VALUES ('test', ' test', 'test

Note that 'test', 'test', 'test is what i entered for each one of those.. I put test in all fields.

What is going wrong?!!?!? Never had this problem before.

Ryan_Sanders

Sorry, but bump.

Hawkee

I had a very similar problem the other day that turned out to do with the space character I was using. Apparently I had pasted my spaces from some other document and mySQL didn't like the particular ASCII character that I was using. I finally figured out that it was the space that was giving me the error. I would try deleting your spaces and replacing them manually. This may not be it, but it's a suggestion.

Hawkee

ahundiak

desc is a reserved word.

http://www.mysql.com/doc/en/Reserved_words.html

Ryan_Sanders

Yea I found that out earlier.. but thanks though.. The wierd thing is that I have used it before. 😉 Maybe it is with the newer MySQL version.