using LIKE in Sql in PHP web page

Question

I have the code below to search for the text 'english' anywhere in the field language. I've tried formatting the code from SQL into a web PHP page but it doesn't display any information. When I run the sql version select language from media where language like '%english%' it works.

$result = mysql_query("SELECT `language` FROM `media` WHERE `language` LIKE \'%english%\'");

while ($row = mysql_fetch_array($result)) {
echo $row[''];
echo ' ' , $row['language'];
echo '<br />';
}

John Conde · Accepted Answer · 2014-06-28 21:56:11Z

1

Don't escape the single quotes around your search term.

$result = mysql_query("SELECT `language` FROM `media` WHERE `language` LIKE '%english%'");

answered Jun 28, 2014 at 21:56

John Conde

220k100 gold badges464 silver badges504 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Fumio Over a year ago

I'm using phpmyadmin and it formatted the php code with the \. thanks its working now.

hichris123 · Accepted Answer · 2014-06-28 21:56:30Z

1

You don't need to escape the ''s. It should just work. So try this:

$result = mysql_query("SELECT `language` FROM `media` WHERE `language` LIKE '%english%'");

answered Jun 28, 2014 at 21:56

hichris123

10.3k15 gold badges58 silver badges70 bronze badges

Collectives™ on Stack Overflow

using LIKE in Sql in PHP web page

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related