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

[oscar at devel.plogworld.net]

Author: oscar
Date: 2005-01-29 20:07:50 +0000 (Sat, 29 Jan 2005)
New Revision: 878

Modified:
   plog/trunk/class/dao/articles.class.php
Log:
fixed issue 172 as reported by jon (http://bugs.plogworld.net/view.php?id=172)

Modified: plog/trunk/class/dao/articles.class.php
===================================================================
--- plog/trunk/class/dao/articles.class.php	2005-01-29 19:58:48 UTC (rev 877)
+++ plog/trunk/class/dao/articles.class.php	2005-01-29 20:07:50 UTC (rev 878)
@@ -361,9 +361,10 @@
                              {$prefix}article_categories_link l";
 			if( $searchTerms != "" )
 				$query .= ", plog_articles_text t ";
-			$query .= " WHERE $where";
+			$query .= " WHERE ";
 			if( $searchTerms != "" )
-				$query .= " AND t.article_id = a.id ";
+				$query .= " t.article_id = a.id AND ";
+			$query .= " $where";
                       
 	
 			// if we're doing a search, we should sort by relevance