title: Select query in codeigniter not working with mysqli
body: <p>Mysql query executed in mysql but not in mysqli and mysql is deprecated so what syntax I have to use for mysqli in codeigniter:</p>
  
  <pre><code> $sql = "SELECT admin_email
                  FROM `tbl_admin`
                  WHERE `admin_email` = '" . $username . "' and `admin_password` = '" . $password . "'"; 
          $query = $this-&gt;db-&gt;query($sql);
  </code></pre>