This is so frustrating! Please help an sql newbie! When I run this query...

mysql_query("INSERT INTO cms_list
(title, htmltitle, name, day, month, year, blurb, cat1, cat2) VALUES ('$title', '$htmltitle', '$filename', '$day', '$month', '$year', '$blurb', '$cat1', '$cat2') ")
or die(mysql_error());

everything's just dandy... but when I run this query...

mysql_query("INSERT INTO cms_list
(title, htmltitle, name, day, month, year, blurb, cat1, cat2, desc, keywords, content) VALUES ('$title', '$htmltitle', '$filename', '$day', '$month', '$year', '$blurb', '$cat1', '$cat2', '$desc', '$keywords', '$content') ")
or die(mysql_error());

I get an error! Why is that? Is there a query limit? all the fields are VARCHAR except 'content' which is TEXT...

Also, I realized why perhaps I've been having errors. Having commas in the text being inserted into the database should not produce errors, should it? I mean, inserting "haha, boo, funny" into 'keywords' shouldn't produce an error should it?

Thanks everybody!

Your problem is that you use a reserved word as a column name

mysql_query("INSERT INTO cms_list
(title, htmltitle, name, day, month, year, blurb, cat1, cat2, desc, keywords, content) VALUES ('$title', '$htmltitle', '$filename', '$day', '$month', '$year', '$blurb', '$cat1', '$cat2', '$desc', '$keywords', '$content') ")
or die(mysql_error());

You must escape them with a backtick character `, to tell mysql that you are using a column name, and not a keyword

mysql_query("INSERT INTO cms_list
(title, htmltitle, name, day, month, year, blurb, cat1, cat2, `desc`, keywords, content) VALUES ('$title', '$htmltitle', '$filename', '$day', '$month', '$year', '$blurb', '$cat1', '$cat2', '$desc', '$keywords', '$content') ")
or die(mysql_error());

http://dev.mysql.com/doc/refman/5.1/...ved-words.html