Using " and ' in a post form errors my database entry
Posted: Tue Apr 13, 2004 2:23 am
I'm not 100% sure if this is a PHP thing, a HTML thing or a MySQL thing so I'll try here anyway. Feel free to move this if it belongs in another category.
I have a bunch of forms, they collect information from page to page, then, at the end, the place all the info into the database.
Everything works perfectly until a user puts an apostrophe or inverted commas (' or ") into their text fields. IE:
If it just has one or the other it still fails so it's not anything to do with using both in the text field.
Does anyone know what this could be? Why I can't use them. Really, if it is like this then people will not know, even if they are told they will forget and I'm going to end up with a lot of errors and the automation I am craving will be lost.
Any help would be very much appreciated.
Thanks again
Rob
I have a bunch of forms, they collect information from page to page, then, at the end, the place all the info into the database.
Everything works perfectly until a user puts an apostrophe or inverted commas (' or ") into their text fields. IE:
Code: Select all
Hello everyone, here's a pic of my "cat woofy".Does anyone know what this could be? Why I can't use them. Really, if it is like this then people will not know, even if they are told they will forget and I'm going to end up with a lot of errors and the automation I am craving will be lost.
Any help would be very much appreciated.
Thanks again
Rob