sql statement with where clause in function

Question

I have written a function that will query the database. The sql statement includes a where clause. However, I keep getting this error

"Message: odbc_exec(): SQL error: [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'home'., SQL state S0022 in SQLExecDirect".

The column name should be banner_category while "home_banner) is the value.

How should I go about achieving it?

public function get_landing_banners()
 {
 $query = $this->db->query(
 'SELECT *
 FROM o2o_banner
 WHERE banner_category='home_banner'');
 $data = array();
 foreach ($query->result_array() as $row) 
 {
 $data[] = $row;
 }
 return $data; 
 }

Answer 1

If you want to return an array try this:

public function get_landing_banners()
{
 $this->db->select('*')->from('o2o_banner')->where('banner_category', 'home_banner');
 $q = $this->db->get();
 if ($q->num_rows() > 0) {
 return $q->result_array();
 }
}

Answer 2

Try this coding

public function get_landing_banners()
 {
 $query = $this->db->query(
 'SELECT *
 FROM o2o_banner
 WHERE banner_category="home_banner"');
 $data = array();
 foreach ($query->result_array() as $row) 
 {
 $data[] = $row;
 }
 return $data; 
 }

• beny lim: Thanks for your help. But I tried this and it have the same error.