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)