Converting double quotes to single quotes

Question

I am little stuck today trying to convert double quote into single quote.

I got this:

$string=" WHERE news_cat='$catid' AND news_title LIKE '%$searchnews%'";

I did this but it didn't work:

$string = ' WHERE `news_cat` = \'' . $catid . '\' AND `news_title` LIKE '%$searchnews%'';

Answer 1

You also need to escape the last single quotes:

LIKE \'%'.$searchnews.'%\'';