[pLog-svn] r3494 - plog/trunk/class/dao

oscar at devel.lifetype.net oscar at devel.lifetype.net
Mon May 29 19:07:48 GMT 2006


Author: oscar
Date: 2006-05-29 19:07:47 +0000 (Mon, 29 May 2006)
New Revision: 3494

Modified:
   plog/trunk/class/dao/articles.class.php
Log:
the article to count the number of articles was broken 


Modified: plog/trunk/class/dao/articles.class.php
===================================================================
--- plog/trunk/class/dao/articles.class.php	2006-05-29 19:03:39 UTC (rev 3493)
+++ plog/trunk/class/dao/articles.class.php	2006-05-29 19:07:47 UTC (rev 3494)
@@ -204,7 +204,7 @@
             $postStatus = $status;
 		    $prefix = $this->getPrefix();
             $where = $this->buildWhere( $blogId, $date, -1, $categoryId, $status, $userId, $maxDate, $searchTerms );
-            $query = "SELECT COUNT(id) AS total FROM {$prefix}articles a, {$prefix}articles_categories c, {$prefix}article_categories_link l WHERE $where ";
+            $query = "SELECT COUNT(a.id) AS total FROM {$prefix}articles a, {$prefix}articles_categories c, {$prefix}article_categories_link l WHERE $where ";
 
             $result = $this->_db->Execute( $query );
             



More information about the pLog-svn mailing list