View Single Post
Old 01-03-2010, 01:34 AM   #1 (permalink)
Killswitch
The Contributor
 
Join Date: Feb 2007
Posts: 64
Thanks: 9
Killswitch is on a distinguished road
Default Having trouble with PDO

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.
Killswitch is offline  
Reply With Quote