Where clause like and apostrophe

[MDanz]

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

[ebmigue]

Most probably you magic_quotes enabled. Thus, when you try to mysql_real_escape it, there is an additional backslash.

 

In short, a double backslash.

 

Disable the feature, and perhaps the problem will be solved.

[MDanz]

i tried but i get the internal 500 server error

 

i put this in my .htaccess file

php_flag magic_quotes_gpc off

 

 

[ebmigue]

Hmm...

 

In short, there is something wrong with the server's setup (w/c PHP might not have involvement with).

 

It would be wise to refer this to your hosting provider's tech. support.

 

Hope it helps.

[MDanz]

when i echo my select query i now get this.

 

SELECT * FROM test WHERE name='q test\'1' ORDER BY `id` DESC LIMIT 10

 

in the database i have a row with name = q test\'1 but it isn't retrieving data.

 

What do i have to change to get the query to retrieve the result.

[fenway]

Well, if your value has a backslash, you'll need to escape it, too.