Ordering DB results by date

[eluser]patrick-vibes[/eluser]
Working now - using the code below. Realised that you define the sorting first, then I am calling the results into a data declaration and passing through to the view.

Code:

<?php

    class Blog extends Controller {
        
        function Blog()
        {
            parent::Controller();
            
            $this->load->scaffolding('portfolio');
            $this->load->helper('url');
        }
        
        function index()
        {
            $data['title'] = "Portfolio Vibes";
            $data['heading'] = "Recent Vibes";
            
            $this->db->orderby("date", "ASC");
            $data['query'] = $this->db->get('portfolio' , 10);
            
            
            $this->load->view('blog_view' , $data);
        }
    
}

?>