A query in multiple tables

[eluser]Sumon[/eluser]
change your controller as

Code:

function comments()
{
    $data['title']= "Comment Title";    

    $SqlInfo="select w.name, c.rating from wines w, wine_comments c where w.id=c.wine_id AND  c.user_id = $logged_in_user_id";
    $query = $this->db->query($SqlInfo);
    $data['query'] = $query->row_array();

    $this->load->view('wine_comment.php', $data);
}