CI Error message in the Model

[eluser]yuro[/eluser]
Hello,

i have a problem. i do through a tutorial of the book "professional codeigniter" and i get this errors:

A PHP Error was encountered

Severity: Notice

Message: Undefined property: Welcome::$db

Filename: core/Model.php

Line Number: 51

Fatal error: Call to a member function get() on a non-object in E:\xampp\htdocs\CI_2.1.3\application\models\mcats.php on line 39

Thats my Code:

Code:

application/models/mcats.php:


function getAllCategories() {
  $data = array();
  $Q = $this->db->get('categories');    //line 39
  
  if($Q->num_rows() > 0) {
   foreach($Q->result_array() as $row) {
    $data[] = $row;
   }
  }
  
  $Q->free_result();
  return $data;

Code:

Model.php:


function __get($key)
{
  $CI =& get_instance();
  return $CI->$key;       //Thats Line 51
}

I use the CodeIgniter Version 2.1.3.. Help please

[eluser]CroNiX[/eluser]
Is the database loaded?

[eluser]yuro[/eluser]
thanks i must declared the database in the autoload.php..

but now i have a different problem.

Here is the Warning:

Fatal error: Call to undefined method CI_DB_mysql_driver::orderby() in E:\xampp\htdocs\CI_2.1.3\application\models\mcats.php on line 41

Code:

function getCategoriesNav() {
  $data = array();
  $this->db->where('parentid <', 1);
  $this->db->where('status', 'active');
  $this->db->orderby('name', 'asc'); //line 41
  
  $Q = $this->db->get('categories');
  
  if($Q->num_rows() > 0) {
   foreach($Q->result_array() as $row) {
    $data[$row['id']] = $row['name'];
   }
  }
  
  $Q->free_result();
  return $data;
}

can you say me, what's the new declaration of the sql command "ORDER BY" by CodeIgniter 2.1.3?

[eluser]CroNiX[/eluser]
Sure, but it's in the user guide so you should probably read that.
Active Record