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.


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
                                              -- 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: [EMAIL PROTECTED]
 DePauw University                 |
 275 Julian Science & Math Center  |
 602 South College Ave.            |
 Greencastle, IN  46135            |

PHP Database Mailing List (
To unsubscribe, visit:

Reply via email to