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
SELECT * FROM bdata WHERE vehicle LIKE 'dimo%' // returns 3 records
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.
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
<?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];
}
?>
Please can someone help