Help needed to Select Count,.

[eluser]quest13[/eluser]
Hi, I need the following in CI, hope someone can help me.


I want to select and count one of the field as well under where condition.
How do I do in CI ?


for ex. Select (some fields here) Count(imgid) from table where productid=$productid


thanks in advance