FORMATTING QUESTION - QUERY & MODEL

[eluser]Barwick[/eluser]
I currently have this in my controller (works and functions as I need it too). Individually grabs a row (3 rows in total) from a "pricing" table and displays the info throughout 3 packages in the view.

(1) My first question - is there any easier way to write this? Or better question, how do I simplify this? I need 3 sets of different variables to display in the view...

(2) Second question - considering this is a database call, it should likely go in the model.
However, I need to send variables to the view. How would I create a model function for this instead? Allowing me to send the necessary variables to my view...

Code:

// Pricing and package details insert from db
        $this->db->select('title, price, number_sites, number_entries, white_label');
        $query = $this->db->get('pricing', 3); // limit 3 rows
        
        $row1 = $query->row(0); // 0 grabs first row in table: Package 1        
        $data['row1'] = $row1;

        $row2 = $query->row(1); // 1 grabs second row in table: Package 2        
        $data['row2'] = $row2;
        
        $row3 = $query->row(2); // 2 grabs third row in table: Package 3        
        $data['row3'] = $row3;                

        // adds view within view, $scripts
        $data['scripts'] = $this -> load -> view('shared/scripts_view', '', TRUE);
          
        $this -> load -> view('shared/header_view', $data);
        $this -> load -> view("subscribe.php", $data);
        $this -> load -> view('shared/footer_view', $data);