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: [EMAIL PROTECTED]
DePauw University |
275 Julian Science & Math Center |
602 South College Ave. |
Greencastle, IN 46135 |
=================================================================
http://www.csc.depauw.edu/RonCroonenberg.html
=================================================================
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
