Kohana Jelly ORM的聚合功能

Question

could you help me to find out how to insert aggregate function using Kohana - Jelly module?

I.E. i need to show result of following query :

SELECT COUNT('total_item') AS tot FROM items WHERE category_id = '1'

really appreciate your help.

thanks

Answer 1

Perhaps something like this would be better:

$count = Jelly::select('item')->where('category', '=', 1)->count();

This would generate this query:

SELECT COUNT(*) AS `total` FROM `items` WHERE `category_id` = 1