+- CodeIgniter Forums (https://forum.codeigniter.com)
+-- Forum: Using CodeIgniter (https://forum.codeigniter.com/forumdisplay.php?fid=5)
+--- Forum: General Help (https://forum.codeigniter.com/forumdisplay.php?fid=24)
+--- Thread: DATABASE ERROR (/showthread.php?tid=78094)
DATABASE ERROR - joeheman - 11-28-2020
I got this error when installing a website:
Error Number: 1054
Unknown column 'status' in 'where clause'
SELECT * FROM `web_slider` WHERE `status` = 1 ORDER BY `slider_id` ASC
Filename: models/website/Web_model.php
Line Number: 95
This is the code:
PHP Code:
public function active_slider()
{
return $this->db->select('*')
->from('web_slider')
->where('status', 1)
->order_by('slider_id', 'asc')
->get()
->result();
Someone should please assist me. thank you
RE: DATABASE ERROR - MIS - 11-28-2020
There is no column called 'status' available in your 'web_slider' table.