Re: [PHP-DB] Inserting a ' into mySQL

2004-08-23 Thread Jonathan Haddad
use mysql_escape_string. http://us3.php.net/manual/en/function.mysql-escape-string.php Jon Ron Piggott wrote: I have begun to create a Christian Ministry Directory. It is on the ministry web site I am building at http://www.actsministries.org/ministrydirectory/ . One of the problems I am now havin

RE: [PHP-DB] Inserting a ' into mySQL

2004-08-20 Thread Ford, Mike [LSS]
> -Original Message- > From: Ron Piggott > Sent: 21/08/04 01:53 [] > One of the problems I am now having is if the user types an ' into their > entry --- these ones do not get saved into the mySQL database. [] > I can look at this and understand that if an ' is keyed why it woul

[PHP-DB] Inserting a ' into mySQL

2004-08-20 Thread Ron Piggott
I have begun to create a Christian Ministry Directory. It is on the ministry web site I am building at http://www.actsministries.org/ministrydirectory/ . One of the problems I am now having is if the user types an ' into their entry --- these ones do not get saved into the mySQL database. The l