Ordering DB results by date

[eluser]patrick-vibes[/eluser]
Using this:

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");    
            $query = $this->db->get('portfolio' , 10);
            $result=$query->result_array() ;
            print_r($result);
            $this->load->view('blog_view' , $data);
        }
    
}

?>

Gives this error:

Code:

A PHP Error was encountered

Severity: Notice

Message: Undefined variable: query

Filename: views/blog_view.php

Line Number: 19

Use short hand? I am trying not too - I know its a but i was worried about server compatibility once completed and migrated.