Ajax autocomplete not case insensitive

[eluser]zulubanslee[/eluser]
Well I decided to try a different tack. I decided to go with writing my own mysql statments, but now my bound parameters aren't working. Here is my controller now.

Code:

$q=$_POST["city_string"];
  $a = '';
  $sql= "SELECT DISTINCT city, state_name
      FROM zip_code
      WHERE lower(city) LIKE ?%";

  
  $city_state_result = $this->db->query($sql, array('city'=>$q));

This is the error message I got.

Code:

<p>Error Number: 1064</p><p>You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '%' at line 3</p><p>SELECT DISTINCT city, state_name
      FROM zip_code
      WHERE lower(city) LIKE 'x'%