Display count of records in Menu

This topic is locked

Display count of records in Menu	3/17/2009 11:28:15 AM
PHPRunner General questions
J jsuisman author Hey all, I'm using phprunner 5.0. I have a menu and would like to display a count of the records for each menu item next to the menu item. Is there any built in way to do this, or do I have to query the database for each count()? Thanks, Jarred


	Sergey Kornilov admin 3/17/2009
	You have to run a (select count(*) from ... ) query against each table in menu. There is no other way to do this.