Data from database not showing up

[eluser]khagendra[/eluser]
Here is your model code

Code:

//getShows Function
function getShows()
{
    //Get Shows Data
    $this->db->get('shows');    
}

Your function getShows just retrieving the data from database but returning no result. So you have to add one more line like this

Code:

//getShows Function
function getShows()
{
    //Get Shows Data
    $query = $this->db->get('shows');
    return $query->result();
}

-- You also have to load the model in ur controller. if the class name of model is Model_name then u can load like this

Code:

class ControllerName extends Controller
{
    function ControllerName()
    {
       parent::Controller();
       $this->load->model('Model_name');
    }
}

to fetch the data, within any function of that controller u can write like this

Code:

$this->Model_name->getShows();

The data will be return as array of objects. so u can write like this

Code:

$data['show_info'] = $this->Model_name->getShows();

Finally, the fields name can be fetched as in ur view like this

Code:

$show_info->field_name;

Note: use the same name of loaded model while fetching the model function. Here is example

Code:

$this->load->model('Model_name');
    then use like this
    $this->Model_name->getShows();
    $this->model_name->getShows() // this will be wrong
  
    OR
    $this->load->model('model_name');
    $this->model_name->getShows();
    $this->Model_name->getShows() // this will be wrong

Hope this will help you solving your problem.