Mysql get, where, order by and limit in one.

[eluser]R. Oerlemans[/eluser]
[quote author="BnoL" date="1246160258"]Hi R. Oerlemans,

Firstly, I think you should not fetch your data in views; do it in your models and return the result as an array, and then assign the array to your views. [/quote]

Thanks for the tip, i've solved that.

Code:

/* Data for song block */            
    $songsQuery = $this->db->get('songs'); // Songs query
    $songsQuery = $this->db->where('artist', $getMysql->id); // Where
    $songsQuery = $this->db->order_by('hits'); // Order by
    $songsQuery = $this->db->limit(15); // Limit, 15 entries
    $songsQuery = $this->db->result_array(); // Fetch All

Fatal error: Call to undefined method CI_DB_mysql_driver::result_array() in *****/application/controllers/artists.php on line 50