Update of /cvsroot/php-blog/jBlog
In directory sc8-pr-cvs1:/tmp/cvs-serv15573
Modified Files:
jBlog_functions.inc.php
Log Message:
fixed support for null categories in fetchEntries
Index: jBlog_functions.inc.php
===================================================================
RCS file: /cvsroot/php-blog/jBlog/jBlog_functions.inc.php,v
retrieving revision 1.62
retrieving revision 1.63
diff -u -d -r1.62 -r1.63
--- jBlog_functions.inc.php 13 Mar 2003 12:47:17 -0000 1.62
+++ jBlog_functions.inc.php 13 Mar 2003 18:18:51 -0000 1.63
@@ -191,7 +191,7 @@
$limit = "LIMIT $limit";
}
- $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 .
+ $query = "SELECT e.*, a.username, 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 (is_string($ret)) {
|
