[Solved] Count where

[eluser]nebulom[/eluser]
Is there any way I can count where? Like

Code:

->count_where('SOME_TABLE', array('COLUMN', $value))

Or any other solution related to this problem? Thanks in advance.

[eluser]davidbehler[/eluser]

Code:

$this->db->where('COLUMN', $value);
$this->db->from('SOME_TABLE');
echo $this->db->count_all_results();

[eluser]nebulom[/eluser]
Ok, thanks. I thought there might be a one-liner solution. Again, thanks a lot.

[eluser]Jagar[/eluser]
If you are using PHP5 you can use the chaining method as follow:

Code:

$this->db->from('table_name')->where('column_name',value)->count_all_results();

this is only available in php5.

http://ellislab.com/codeigniter/user-gui...ecord.html

[eluser]nebulom[/eluser]
Yes, and I'm with PHP4 so can't use chain methods. Thanks.