List:General Discussion« Previous MessageNext Message »
From:Ludwig Pummer Date:July 26 2005 2:32am
Subject:Re: Quotation marks in string causing repace to not work.
View as plain text  
Gregory Machin wrote:
> I tried the following  
> 
> UPDATE temp SET 'file_content' = REPLACE(file_content, '<?php
> require($_SERVER['DOCUMENT_ROOT']."/scripts/define_access.php");?>' ,
> '');
> 
> 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. Also, did you mean to write 
'file_content', or `file_content` ?

Try

UPDATE temp SET `file_content` = REPLACE(file_content, '<?php 
require($_SERVER[\'DOCUMENT_ROOT\']."/scripts/define_access.php");?>', '');
Thread
Quotation marks in string causing repace to not work.Gregory Machin25 Jul
  • Re: Quotation marks in string causing repace to not work.Ludwig Pummer26 Jul