I have a query that returns results:
user_id site_id count_site
1 2 2
2 1 1
1 3 1
$topSites = Site::model()->findAllBySql("
SELECT user_id, site_id, COUNT( site_id ) AS count_site
FROM tbl_site
GROUP BY site_id
ORDER BY count_siteDESC
LIMIT 0 , 30");
I tried $topSites->count_site… Property "Site.count_site" is not defined.
how can i access count_site values?