Very Weird Mysql Problem

[eluser]smatakajr[/eluser]
Hey Guys

I really banged my head on this and now im clue less to why and im asking for your
thoughts

I have like 30 update statements that work on different tables throughout
the application and they all function as intended.

This one particular update statement will not work for the life of me
UNLESS you use backticks for the fields identifiers

SO this dont work

update inbox set read=1 where inbox_id=1 and affiliates_id=1

and this does

update `inbox` set `read`=1 where `inbox_id`=1 and `affiliates_id`=1

I even recreated the table from scratch

Any Thoughts?

Thanks
Rick

[eluser]kgill[/eluser]
It's because you're using a reserved word as one of your column names: read

[eluser]smatakajr[/eluser]
Thanks I noticed that after i pulled my hair out for a bit

Thanks
Rick!!