Two table query and then using the two arrays question

[eluser]Mainboard[/eluser]
well, you can try with this

Model

Code:

function get_widgets_colours() {
     $q = $this->db->select('*')->from('widgets')->join('colour', 'widgets.id = colour.id') ;
      $ret['rows'] = $q->get()->result();
     return $ret;
    }