title: using LIKE in Sql in PHP web page
body: <p>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 <code>language</code> from <code>media</code> where <code>language</code> like '%english%' it works.</p>
  
  <pre><code>$result = mysql_query("SELECT `language` FROM `media` WHERE `language` LIKE \'%english%\'");
  
  while ($row = mysql_fetch_array($result)) {
  echo $row[''];
  echo ' ' , $row['language'];
  echo '&lt;br /&gt;';
  }
  </code></pre>