[SOLVED] Just a really quick question: Whats wrong with the insert?

[jrws]

Here's the mysql query:

INSERT INTO forum_sub_cats(name,desc)
							VALUES('Random','Random Description')

I have checked that everything exists, and those values are pseudo values mind you, however it spits 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) VALUES('Random','Random Description')' at line 1

So whats wrong with it?

It will accept this one:

INSERT INTO forum_sub_cats(name,admin)VALUES('$name','$admin')

And for the life of me I can't find an answer..

[Mark Baker]

DESC - reserved word used in ORDER BY clauses

Enclose it in backticks when using it as a table or column name

Or better yet, change your column name

[jrws]

Thanks mate, I didn't realize.