strange symptoms...

Anon

I am having a problem with MySQL's UPDATE function with PHP. I would post in the MySQL forum but I think the problem lies in my PHP syntax. I'm trying to write a simple message board and it is not updating the number of replies. Here's the line that's not working:

mysql_query('UPDATE topic SET replies=replies+1 WHERE messageID='.$ID.';');

If I use an actual integer instead of concatenating the strings (e.g. "messageID=1;") it works. Also, another update statement:

mysql_query('UPDATE message SET next='.$msgid.' WHERE messageID='.$lastMsg.';');

which also contains concatenated strings works perfectly. the syntax in the two statements is nearly identical. can anyone identify my problem?

Anon

nevermind, I found it. After an hour of looking and looking... $ID was not being properly passed from the previous page... duh, first place to look... thanks anyway.

Anon

Like I have said many many times:
"If your query doesn't do what you think it should do, print the flipping thing and see what it is you are doing." :-)

Also, you might want to include error-checking to check if your query worked at all.

Anon

:-)

I usually find this type of mistake by now, that's why I was so befuddled... I think it has to do with staying up all night writing code. After a while it doesn't make sense any more.

Anon

Staying up all night to write code? Man, what are you doing? it's the last day of the year, you should have been in bed early to party tonight!

happy newyear!

Anon

Also when you start getting so tired you don't understand the code anymore you run the risk of making a critual mistake. Such as deleteing your whole project by accident. Only so much work can be done in one day.