Count All

[eluser]rochellecanale[/eluser]
hello guys how can i convert this code in active record:

Code:

$last_points = mysql_insert_id();
$sql = "SELECT COUNT(fkmember) FROM downline WHERE fkmember = {$last_points}";

any idea?

[eluser]Beginers[/eluser]
http://ellislab.com/codeigniter/user-gui...ecord.html

Code:

$this->db->where('fkmember', $last_points);
$this->db->from('downline');
echo $this->db->count_all_results();

[eluser]rochellecanale[/eluser]
i got 0 when i run it. what's wrong?

[eluser]Beginers[/eluser]
I think the variable you supplied does not match in the db you. Try to use like function.

Code:

$this->db->like('fkmember', $last_points);
$this->db->from('downline');
echo $this->db->count_all_results();