Re: [PHP] Re: mysql input

2008-02-19 Thread admin
Filter the data $data = str_replace("'", "", $data); I am sure there are many ways to filter the data before insert. (If you are SURE you have "A.D.D." then it wont matter what I say to you.) Rick B. On Feb 18, 2008 11:24 PM, Shawn McKenzie <[EMAIL PROTECTED]> wrote: > nihilism machine w

Re: [PHP] Re: mysql input

2008-02-19 Thread Daniel Brown
On Feb 18, 2008 11:24 PM, Shawn McKenzie <[EMAIL PROTECTED]> wrote: > nihilism machine wrote: > > I have a user saving a VARCHAR(255) field in a mysql db which has single > > quotes in the text, how can i replace them so that they dont fuck up my > > mysql command? > > > > -e > > > Have you tried:

Re: [PHP] Re: mysql input

2008-02-19 Thread Nathan Rixham
Bastien Koert wrote: thats awesome bastien> To: php-general@lists.php.net> Date: Tue, 19 Feb 2008 11:21:02 +> From: [EMAIL PROTECTED]> Subject: Re: [PHP] Re: mysql input> > Zoltán Németh wrote:> > 2008. 02. 19, kedd keltezéssel 11.03-kor Nathan Rixham ezt írta:

RE: [PHP] Re: mysql input

2008-02-19 Thread Bastien Koert
thats awesome bastien> To: php-general@lists.php.net> Date: Tue, 19 Feb 2008 11:21:02 +> From: [EMAIL PROTECTED]> Subject: Re: [PHP] Re: mysql input> > Zoltán Németh wrote:> > 2008. 02. 19, kedd keltezéssel 11.03-kor Nathan Rixham ezt írta:> >> Richard

Re: [PHP] Re: mysql input

2008-02-19 Thread Nathan Rixham
Nathan Rixham wrote: Zoltán Németh wrote: 2008. 02. 19, kedd keltezéssel 11.03-kor Nathan Rixham ezt írta: Richard Heyes wrote: Shawn McKenzie wrote: nihilism machine wrote: I have a user saving a VARCHAR(255) field in a mysql db which has single quotes in the text, how can i replace them so

Re: [PHP] Re: mysql input

2008-02-19 Thread Nathan Rixham
Zoltán Németh wrote: 2008. 02. 19, kedd keltezéssel 11.03-kor Nathan Rixham ezt írta: Richard Heyes wrote: Shawn McKenzie wrote: nihilism machine wrote: I have a user saving a VARCHAR(255) field in a mysql db which has single quotes in the text, how can i replace them so that they dont fuck u

Re: [PHP] Re: mysql input

2008-02-19 Thread Zoltán Németh
2008. 02. 19, kedd keltezéssel 11.03-kor Nathan Rixham ezt írta: > Richard Heyes wrote: > > Shawn McKenzie wrote: > >> nihilism machine wrote: > >>> I have a user saving a VARCHAR(255) field in a mysql db which has single > >>> quotes in the text, how can i replace them so that they dont fuck up my

Re: [PHP] Re: mysql input

2008-02-19 Thread Nathan Rixham
Richard Heyes wrote: Shawn McKenzie wrote: nihilism machine wrote: I have a user saving a VARCHAR(255) field in a mysql db which has single quotes in the text, how can i replace them so that they dont fuck up my mysql command? -e Have you tried: dont_fuck_up_my_mysql_command() Hrmph, I c

Re: [PHP] Re: mysql input

2008-02-19 Thread Richard Heyes
Shawn McKenzie wrote: nihilism machine wrote: I have a user saving a VARCHAR(255) field in a mysql db which has single quotes in the text, how can i replace them so that they dont fuck up my mysql command? -e Have you tried: dont_fuck_up_my_mysql_command() Hrmph, I can't seem to find that