MySQL query to get number of posts

MySQL query to get number of posts

El Forum
Unregistered

11-05-2008, 09:32 AM

[eluser]CodeIgniterNoob[/eluser]
Its not working. My function selects the categories table and gets the id and name fields. Then the controller prints the name of the category to a view, when you click on the category it then takes you to a page displaying all the posts that belong to that category.

I just want to add a number of published posts on the bottom of each category link, a number of posts which belong to that category.

Messages In This Thread

MySQL query to get number of posts - by El Forum - 11-04-2008, 11:06 AM

MySQL query to get number of posts - by El Forum - 11-04-2008, 02:28 PM

MySQL query to get number of posts - by El Forum - 11-04-2008, 03:06 PM

MySQL query to get number of posts - by El Forum - 11-04-2008, 05:41 PM

MySQL query to get number of posts - by El Forum - 11-04-2008, 07:59 PM

MySQL query to get number of posts - by El Forum - 11-05-2008, 09:32 AM

MySQL query to get number of posts - by El Forum - 11-05-2008, 10:48 AM

MySQL query to get number of posts - by El Forum - 11-05-2008, 11:54 AM