![]() |
ORDER BY COUNT - Printable Version +- CodeIgniter Forums (https://forum.codeigniter.com) +-- Forum: Archived Discussions (https://forum.codeigniter.com/forum-20.html) +--- Forum: Archived General Discussion (https://forum.codeigniter.com/forum-21.html) +--- Thread: ORDER BY COUNT (/thread-29982.html) |
ORDER BY COUNT - El Forum - 04-28-2010 [eluser]aruntvla[/eluser] Order the category according to the number of post.. Is thre any idea about how i sort a category list using the count of post.. in my case count is an integer number but how it use with an ORDER BY query..help me plz.. ORDER BY COUNT - El Forum - 04-28-2010 [eluser]pickupman[/eluser] Have you tried: Code: $this->db->select('*, COUNT(category_id) as rows'); |