[Resolved] SQL syntax error help

Cojiro

Hello again.

Once I get more of a hang of this stuff, I probably wont have as many silly questions. So, here we go:

I am trying to update my database with a somewhat long list of variables. I have, earlier, taken the query out and echoed the variables just to make sure that they contained the right things and were approaching the query as they should. That was fine.

However, with my query in, I get the following error message:

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 'now(), now(), '', 'Testing article...', '0', '1', '0', '0', '0'

This is the query:

	$query = mysql_query("INSERT INTO news (article_number, date, time, heading, article, flag_gamecube, flag_ps2, flag_xbox, flag_handheld, flag_retro, flag_developer, flag_media, flag_site, flag_staff) VALUES (,now(), now(), '$heading', '$article', '$gamecube', '$ps2', '$xbox', '$handheld', '$retro', '$developer', '$media', '$site', '$staff')")
		or die (mysql_error());

First one sent auto-increments. Second and third are date and tie respectively. Thanks in advance for the help.

paulnaj

So, is the field ... article_number ... an auto_increment?
If so, try using NULL in the VALUES section. That is, ...

$query = mysql_query("INSERT INTO news (article_number, date, time, heading, article, flag_gamecube, flag_ps2, flag_xbox, flag_handheld, flag_retro, flag_developer, flag_media, flag_site, flag_staff) VALUES (NULL,now(), now(), '$heading', '$article', '$gamecube', '$ps2', '$xbox', '$handheld', '$retro', '$developer', '$media', '$site', '$staff')") 
        or die (mysql_error());

Cojiro

Yes, article_number was the one bring auto-incremented, and that fix worked perfectly. Thank you. 🙂

One other slight problem showing up now (and it did before, too, because the header field was coming up as blank in the error message) it comes up blank now in the database too, which I find odd.

I echoed the header variable right before the query as a test, and it echoed fine. header is set as varchar(75).

I'm going to look into this more, but in the meantime, if anyone else knows what the problem may be, do tell please.

paulnaj

You are talking about a 'header' field ...

I echoed the header variable right before the query as a test, ...

but your code refers to 'heading'.

Could that be it?

Cojiro

Ooooh, goodness... yep, that's it.

I had named the database column "heading" and the variable "header" which got me confused.

Thanks again!

paulnaj

No problem.

I do that sort of thing all the time! Wasted hours ...