[php-blog-cvs] jBlog jBlog_functions.inc.php,1.58,1.59

[<gsc...@us...>]

Update of /cvsroot/php-blog/jBlog
In directory sc8-pr-cvs1:/tmp/cvs-serv1557

Modified Files:
	jBlog_functions.inc.php 
Log Message:
fixed for disapeering authors


Index: jBlog_functions.inc.php
===================================================================
RCS file: /cvsroot/php-blog/jBlog/jBlog_functions.inc.php,v
retrieving revision 1.58
retrieving revision 1.59
diff -u -d -r1.58 -r1.59
--- jBlog_functions.inc.php	13 Mar 2003 04:18:26 -0000	1.58
+++ jBlog_functions.inc.php	13 Mar 2003 06:27:35 -0000	1.59
@@ -189,7 +189,7 @@
         $limit = "LIMIT $limit";
     }
 
-    $query = "SELECT e.*, c.category_name FROM {$jBlog['dbPrefix']}entries e, {$jBlog['dbPrefix']}authors a left join {$jBlog['dbPrefix']}category c ON e.categoryid = c.categoryid  WHERE e.authorid = a.authorid " . $and .
+    $query = "SELECT e.*, a.*, c.category_name FROM {$jBlog['dbPrefix']}entries e, {$jBlog['dbPrefix']}authors a left join {$jBlog['dbPrefix']}category c ON e.categoryid = c.categoryid  WHERE e.authorid = a.authorid and e.authorid = c.authorid " . $and .
              "ORDER BY timestamp DESC $limit";
     $ret = jBlog_db_query($query);
     if (!$ret) {