title: SQL query works on phpmyadmin but not on php
body: <p>Hi I have a strange problem with below sql query.
  If I run the query on sql console on phpmyadmin it returns 3 "dimo" vehicle records</p>
  
  <pre><code>SELECT * FROM bdata WHERE vehicle LIKE 'dimo%' // returns 3 records
  </code></pre>
  
  <p>but if I make a php file and run it does not return any records but if I change the search to car it shows all the records under car.</p>
  
  <p>Please can someone help I tried many things including changing database structure but did not work. I spent almost a week to fix this issue before seeking help on stackoverflow</p>
  
  <pre><code>&lt;?php
      define('HOST','****');
      define('USER','****');
      define('PASS','*****');
      define('DB','*******');
  
      $con = mysqli_connect(HOST,USER,PASS,DB);
  
      $sql = "SELECT * FROM bdata WHERE vehicle LIKE 'dimo%' ORDER BY vehicle";
      // database has three dimo vehicles but does not show on the php
      // but works fine on phpmyadmin console
  
      $res = mysqli_query($con,$sql); 
      while ($row = mysqli_fetch_array($res))
      {
          echo $row[15];     
      }   
  ?&gt;
  </code></pre>
  
  <p>Please can someone help</p>