help with quotes

[andz]

consider the following string including quotes, how do i removed the inner quotes only???

 

'%'testinghere'%'

[Alt_F4]

how does that NOT throw an error??

 

you could do:

 

$str = str_replace("'%'","'%","'%'testinghere'%'");

[DarkSuperHero]

that particular string would need to be wrapped with different quotes (double quotes) to not throw an error otherise it would need to be excaped.....

//notice Alt_F4's string was also wrapped in double quotes containing the single inner quotes..
$str = str_replace("'%'","'%","'%'testinghere'%'");

//this will be ok...
$someVariable1 = '%\'testinghere\'%';  //escaped the inner quotes with backslash \ .....

//wrong way.... will throw an error
$someVariable2 = '%'testinghere'%';

[andz]

how can i apply this on a solution? like str_replace

 

thanks

 

that particular string would need to be wrapped with different quotes (double quotes) to not throw an error otherise it would need to be excaped.....

//notice Alt_F4's string was also wrapped in double quotes containing the single inner quotes..
$str = str_replace("'%'","'%","'%'testinghere'%'");

//this will be ok...
$someVariable1 = '%\'testinghere\'%';  //escaped the inner quotes with backslash \ .....

//wrong way.... will throw an error
$someVariable2 = '%'testinghere'%';

[andz]

here's the complete code that where i want it to apply.

 

SELECT * FROM `test` WHERE `user` LIKE '%'coder'%'

[Maq]

In your original post, you said you want to remove the inner single quotes.  If you want to keep them, then you need to escape them, if not, then you can remove them.  Which do you want to do?