Code ignitier MySQL query

Question

I'm getting an error with this function: Controller $data['carSubwoofers'] = $this->db->get_where("department = 'MOBILE AUDIO' AND class = 'CAR STEREO' AND subclass IN ('SO CAR STEREO','SUBS','SO SUBS')")->result(); $this->load->view('Category/carSubwoofers',$data); View foreach($data->result() as $row) { ?> <?php echo $row->modelNumber; ?> <?php echo $row->name; ?> <?php } ?> Code igniter shoots out this: A Database Error Occurred Error Number: 1064 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 ''MOBILE AUDIO' AND class = 'CAR STEREO' AND subclass IN ('SO CAR STEREO' at line 2 SELECT * FROM (department = 'MOBILE AUDIO' AND class = 'CAR STEREO' AND subclass IN ('SO CAR STEREO', 'SUBS', 'SO SUBS')) Filename: C:\Program Files (x86)\Apache Software Foundation\Apache2.2\htdocs\CodeIgniter_2.0.2\system\database\DB_driver.php Line Number: 330 JavaScript questions and answers, JavaScript questions pdf, JavaScript question bank, JavaScript questions and answers pdf, mcq on JavaScript pdf, JavaScript questions and solutions, JavaScript mcq Test , Interview JavaScript questions, JavaScript Questions for Interview, JavaScript MCQ (Multiple Choice Questions)

Answer 1

You can chain your conditionals together to make it look cleaner too. $this->db->where('department', 'MOBILE AUDIO')->where('class', 'CAR STEREO')->where_in('subclass', array('SO CAR STEREO','SUBS','SO SUBS'))->get('tableName');