Re: Using apostrophe's within a text field

There is that mysql function that is meant for prevention of sql injection when a single quote or so is entered sql starts acting up. because the sql syntax is not correct anymore. then your sql functions start acting up and you get to see all those informative msgs Turning a ' into a '' or a " into a "" works too, but the mysql function for that works better safer etc. Ron Stephen Smith wrote: > OK guys, here is my delima, which is probably very easy to solve, but I can't seem to find > it. I am trying to get form fields to accept apostrophes within the input and stop crashing on me. > I'm writing forms into a mysql database and everything works great unless the user enters a > word like "won't" or "can't". Them it crashes during the form submit. > What can I do to fix this stupid thing anyway? > > thanks in advance. > > Steve Smith > -- ================================================================= It's is not, it isn't ain't, and it's it's, not its, if you mean it is. If you don't, it's its. Then too, it's hers. It isn't her's. It isn't our's either. It's ours, and likewise yours and theirs. -- Oxford Uni Press ================================================================= Ron Croonenberg | | Phone: 1 765 658 4761 Lab Instructor & | Fax: 1 765 658 4732 Technology Coordinator | | Department of Computer Science | e-mail: ronc@DePauw.edu DePauw University | 275 Julian Science & Math Center | 602 South College Ave. | Greencastle, IN 46135 | ================================================================= http://www.csc.depauw.edu/RonCroonenberg.html =================================================================