I have table name classification and columns ‘class_id’ and ‘class_name’. Now, I want to display a list of objects that belongs to same classification using CDbCriteria.
Ex. Classification[list=1]
[*]Equipment -3
[*]Crops -2
[*]Services -1
[/list]
How can I display only items that has value and their count that belongs to class ‘Equipment’, etc.? If there is no item that belongs to class Crops ( Crops=0), no need to display.
Thank you. Hope you can help me.