--- a/lib/autocomplete.php +++ b/lib/autocomplete.php @@ -3,7 +3,7 @@ $result = Array(); if (isset($_REQUEST['term'])) { $term = filter_var($_REQUEST['term'], FILTER_SANITIZE_STRING); - $query = "Select stop_name,min(stop_lat) as stop_lat,min(stop_lon) as stop_lon from stops where stop_name LIKE :term group by stop_name"; + $query = "Select stop_name,min(stop_lat) as stop_lat,min(stop_lon) as stop_lon from stops where stop_name ILIKE :term group by stop_name"; $query = $conn->prepare($query); $term = "$term%"; $query->bindParam(":term", $term);