php-blog-cvs

[<tom...@us...>]

Update of /cvsroot/php-blog/serendipity
In directory sc8-pr-cvs1:/tmp/cvs-serv3426

Modified Files:
	serendipity_functions.inc.php 
Log Message:
Fixed b0rked SQL query sorting comments in the wrong direction


Index: serendipity_functions.inc.php
===================================================================
RCS file: /cvsroot/php-blog/serendipity/serendipity_functions.inc.php,v
retrieving revision 1.113
retrieving revision 1.114
diff -u -d -r1.113 -r1.114
--- serendipity_functions.inc.php	8 Aug 2003 10:00:20 -0000	1.113
+++ serendipity_functions.inc.php	8 Aug 2003 14:38:42 -0000	1.114
@@ -614,14 +614,12 @@
                     e.id AS entryid,
                     c.category_name
               FROM
-                    ({$serendipity['dbPrefix']}comments co
-                    LEFT JOIN {$serendipity['dbPrefix']}entries e
-                        ON co.entry_id = e.id
-                    LEFT JOIN {$serendipity['dbPrefix']}category c
-                        ON e.categoryid = c.categoryid)
+                    {$serendipity['dbPrefix']}comments co
+                    LEFT JOIN {$serendipity['dbPrefix']}entries e ON (co.entry_id = e.id)
+                    LEFT JOIN {$serendipity['dbPrefix']}category c ON (e.categoryid = c.categoryid)
                     WHERE co.type LIKE 'NORMAL' $and
                     ORDER BY
-                        co.id DESC
+                        co.id
                     $limit";
 
     $comments = serendipity_db_query($query);