Gregory Machin wrote:
I tried the following
UPDATE temp SET 'file_content' = REPLACE(file_content, '' ,
'');
but it didn't work, i think thing problem is that the string i need to
replace / null has quotation marks .. how can i work around this
You need to escape the quotation marks. A
Bill:
What about the DBI's quote() method... isn't this what its for?
http://www.mysql.com/doc/P/e/Perl_DBI_Class.html
Keith
-Original Message-
From: Bill Platt [mailto:[EMAIL PROTECTED]]
Sent: Saturday, March 02, 2002 2:25 AM
To: [EMAIL PROTECTED]
Subject: Quotation Marks in Mysql fiel
On Saturday, 2. March 2002 08:24, Bill Platt wrote:
> Now, my question is this. How do I get the database to accept
> the quotation marks and apostrophes?? The kind of data I am
> entering into the tables is better with these items left in
> rather than left out.
>
Hello Bill,
all you have to do
> What is the best way to deal with both single and double quotation marks
> ' "
> when using php and mysql? I seem to be generating a lot of errors due to
> these special characters.
use functions addslashes and stripslashes when inserting and
retrieving, resp.
See http://php.net/manual/en/fun
