i'm not getting any results for the query. I'm sure it has something to do with the apostrophe and back slashes
$search = "q test'yes"; $search = mysql_real_escape_string($search); mysql_query("SELECT * FROM block WHERE name LIKE '%$search%' ORDER BY `id` DESC",$this->connect);
When i echo it out i get this
SELECT * FROM block WHERE name LIKE '%q test\\\'yes%' ORDER BY `id` DESC
is there a solution to this without turning off magic quotes?