Help With This Query

[Darren884]

UPDATE `top_site_users` SET out = out+1 WHERE user_id = '1' AND top_site_id = '1' AND id = '1'

It has something to do with out = out + 1 I just can't grasp it. phpMyAdmin says its around that area.

[r937]

is there any chance that OUT might be a reserved word?

try putting it in backticks -- this `escapes` it and treats it like an identifier, i.e. column name

note that you do not need the backticks around top_site_users, because that isn't a reserved word, nor does it contain any special characters (the other reason that backticks are sometimes needed)


oh, and by the way, please don't compare your numeric columns to strings

change this --

... WHERE user_id = '1' AND top_site_id = '1' AND id = '1'

to this --

... WHERE user_id = 1 AND top_site_id = 1 AND id = 1

[Darren884]

Ah thanks thats what I had forgotten