A query in multiple tables

[eluser]ray73864[/eluser]
or if you want to keep with the approach you were on, use:

Code:

$this->db->select('w.name, c.rating');
$this->db->from('wines w');
$this->db->where('user_id', getUserProperty('id'));
$this->db->join('wine_comments wc','w.id = wc.wine_id');

$data['query']= $this->db->get();

either of the 2 ways will work fine, just depends on which way you want to go.