More Form -> mySQL problems

[SilverX]

I just don't get it. Why would this work:

$result = mysql_query ("INSERT INTO events (date, title) values ('" . $HTTP_POST_VARS[date] . "','" . $HTTP_POST_VARS[title] . "')", $dbh);

But this not:

$result = mysql_query ("INSERT INTO events (date, title, desc) values ('" . $HTTP_POST_VARS[date] . "','" . $HTTP_POST_VARS[title] . "','" . $HTTP_POST_VARS[desc] . "')", $dbh);

No data getting to the db. Again.

I'll think I'll have to give up with php and mysql; the most basic things that work for other people just don't happen for me.

[NicM]

Perhaps because 'desc' is the mySQL command to list items in descending order?

Have you tried changing the name of that variable?

[khaldryck]

i think that's just because desc is a reserved word in Mysql
change the name to descr or description, and it should work.

[SilverX]

Originally posted by khaldryck
i think that's just because desc is a reserved word in Mysql
change the name to descr or description, and it should work.

Ugh! That's it!

Thanks people.

worships