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

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

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

Modified Files:
	jBlog_functions.inc.php 
Log Message:
small query fix


Index: jBlog_functions.inc.php
===================================================================
RCS file: /cvsroot/php-blog/jBlog/jBlog_functions.inc.php,v
retrieving revision 1.57
retrieving revision 1.58
diff -u -d -r1.57 -r1.58
--- jBlog_functions.inc.php	13 Mar 2003 03:35:59 -0000	1.57
+++ jBlog_functions.inc.php	13 Mar 2003 04:18:26 -0000	1.58
@@ -189,7 +189,7 @@
         $limit = "LIMIT $limit";
     }
 
-    $query = "SELECT * 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.*, 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 .
              "ORDER BY timestamp DESC $limit";
     $ret = jBlog_db_query($query);
     if (!$ret) {