Ok I have ran into an issue with populating a MySQL database with a last name that has the "'" in it. The solution for me was to use the function htmlspecialchars() to process the last name then insert it into a record. Just like the last name other fields could have special charecters that I want to preserve. So is it best practice to process any input into mysql with htmlspecialchars() that is user inputed text?
Thanks in Advance
