Nesting queries within active record

[eluser]Sumon[/eluser]
have a look the following code. may be helpful to understand
Controller :

Code:

$Data['Recordsets'] = $this->model_name->MemberProfile($MemberId);
$this->load->view("member/view_all_member_info",$Data);

Model : (model_name.php)

Code:

function MemberProfile($MemberId)
    {
    $query = $this->db->query("SELECT Com.*, Login.mem_id, Login.mem_primary_photo, Profile.mem_first_name, Profile.mem_last_name FROM image_gallery_image_comment Com, member_login Login, member_profile Profile WHERE Com.image_id='$PhotoId' AND Com.mem_id=Login.mem_id AND Profile.member_id=Login.mem_id");
    if ($query->num_rows() > 0)
    {
            $i=0;
            foreach($query->result() as $val):
                foreach($val as $Key=>$Value):
                                  if($Key=="mem_primary_photo") //for example this is your car model(Ford)
                                     $MemberPhoto[$i] = $Value;
                                  else
                                     $AllInfo[$i][$Key]=$Value;
                endforeach;
                $i++;
            endforeach;
            return $Comments;
        }
        else
            return FALSE;
    }

View : (view_all_member_info.php)

Code:

if(count($Recordsets->result())==0)    echo "Sorry no member exists.";
    <?php foreach($Recordsets->result() as $row): ?>
        <?=$row->site_feature_name;?>
    <?php endforeach; ?>