IS NOT NULL using database helper

[eluser]Phil Sturgeon[/eluser]

Code:

$this->db->where('surname IS NOT NULL');
$query = $this->db->get('users');
$data[‘reg_count’] = $query->num_rows;

It's possible you could do it this way too:

Code:

$query = $this->db->get_where('users', array('surname !=' => NULL));
$data[‘reg_count’] = $query->num_rows;