I am having a bit of trouble with an SQL statement and really don't know why.
Basically I am updating a forums information in the database. Everything is fine until I use certain characters.
For whatever reason, I can use moderators and administrators, but not moderators and administrators ONLY. Trespassers will be violated.
If it manages to update, the ONLY part of that string and on turns into >, so it reads moderators and administrators >.
Before going into the database I am using trim(htmlspecialchars($form_data, ENT_QUOTES)) and using them in a prepared query. I really don't understand what could be causing this and never ran into this problem before.
If it helps, the field this is getting inserted into is called desc (which I had probs with before, had to use `desc` to get it to work) which is just a text type field in mysql.