[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