http://www.digitalbase.eu/blog A blog about webdesign, PHP, development and IT Mon, 10 May 2010 16:16:55 +0000 http://backend.userland.com/rss092 en To reduce the query count in your web application, you might consider using subqueries. I'll show you howto do that in propel/symfony : [code]propel - subqueries[/code] It's that easy :) http://www.digitalbase.eu/blog/symfony-propel-subquerys/ Simplifying Queries: Using sum, count, etc in Propel $c->addSelectColumn('sum('.dbTimeBlockPeer::TOTAL.') as total'); $rs = dbTimeBlockPeer::doSelectRS($c); while ($rs->next()) { $total = $rs->getInt(1); } So, simply use addSelectColumn. You have to work with the ResultSet offcourse, since you won't be able to populateObjects. In this case you can simply use '1' in getInt(column index), since we're sure only ... http://www.digitalbase.eu/blog/simplifying-queries-using-sum-count-etc-in-propel/