[geeklog-cvs] geeklog: fix group by sql clause

[geeklog-cvs at lists.geeklog.net]

changeset 7828:d5a6207649aa
url:  http://project.geeklog.net/cgi-bin/hgwebdir.cgi/geeklog/rev/d5a6207649aa
user: stan <stan at spalatnik.com>
date: Wed Mar 24 08:47:48 2010 -0400
description:
fix group by sql clause

diffstat:

 plugins/links/functions.inc |  2 +-
 1 files changed, 1 insertions(+), 1 deletions(-)

diffs (12 lines):

diff -r 65910f8ef6c6 -r d5a6207649aa plugins/links/functions.inc
--- a/plugins/links/functions.inc	Tue Mar 23 20:34:46 2010 -0400
+++ b/plugins/links/functions.inc	Wed Mar 24 08:47:48 2010 -0400
@@ -479,7 +479,7 @@
 
     $feeds = array ();
 
-    $result = DB_query ("SELECT cid,category FROM {$_TABLES['linkcategories']} GROUP BY category ORDER BY category ASC");
+    $result = DB_query ("SELECT cid,category FROM {$_TABLES['linkcategories']} GROUP BY cid,category ORDER BY category ASC");
     $num = DB_numRows ($result);
 
     if ($num > 0) {