Welcome Guest, Not a member yet? Register   Sign In
DATABASE ERROR
#1

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

Attached Files Thumbnail(s)
   
Reply
#2

There is no column called 'status' available in your 'web_slider' table.
Reply




Theme © iAndrew 2016 - Forum software by © MyBB