Re: problem with mysql_query
| From: | Markus Lervik | Date: | Mon, 10 Jun 2002 11:42:37 +0000 |
| Subject: | Re: problem with mysql_query | ||
| References: | 1 2 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-19712@lists.php.net to get a copy of this message | ||
On Monday 10 Jun 2002 2:37 pm, Markus Lervik wrote:
> On Monday 10 Jun 2002 2:15 pm, Rene Schoenmakers wrote:
> > Hi,
> >
> > I know what's causing the problem. In $newsText sometimes single quotes
> > are entered. There the error occurs. How can I escape these singel
> > quotes?
>
> with $newsText = addslashes($newsText);
>
> http://www.php.net/manual/en/function.addslashes.php
Oh yea, forgot to mention, when pulling the field back from the database, use
the stripslashes -function in the same manner.
Cheers,
Markus
--
Markus Lervik
Linux-administrator
Vaasa City Library - Regional Library, Finland
markus.lervik@vaasa.fi
+358-6-325 3589/+358-40-832 6709