Welcome Guest, Not a member yet? Register   Sign In
Controller not displaying data
#1

[eluser]Unknown[/eluser]
i am trying to display data from database but what i am getting is blank fields only.
i have referred article "http://ellislab.com/forums/viewthread/133951/" but i need only one result so i have used $query->row(0).
can any body tell me what correction i need to carried out in following code.
Code:
//controller code

  parent::__construct();
  $blogi=array();
  $this->load->model('blogs');
  //$blogi['info']=$this->blogs->views();
  $blogi['rows']=$this->blogs->views();
  
  $this->load->view('blog_index',$blogi);
Code:
//model code
                $this->db->select('Mood,Date,BlogTitle,BlogDescription');
  $this->db->where('Mood','happy');
  $this->db->from('blogs');
   $this->db-> limit(1);
  
   $bsql=$this->db->get();
   if($bsql->num_rows()>0)
   {
    //$row=$bsql->row();
   //$info=$row;
    return $bsql->result();
   }
   else
   {
    return false;
   }

Code:
//view code
                
  <?php echo $rows['BlogTitle']; ?>
  <?php echo $rows['Mood']; ?>
  <?php echo $rows['Date']; ?>
thanks allot




Theme © iAndrew 2016 - Forum software by © MyBB