librefm-commits
[Top][All Lists]
Advanced

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

[Librefm-commits] [1601] this might work?


From: Matt Lee
Subject: [Librefm-commits] [1601] this might work?
Date: Thu, 14 May 2009 20:41:58 +0000

Revision: 1601
          http://svn.sv.gnu.org/viewvc/?view=rev&root=librefm&revision=1601
Author:   mattl
Date:     2009-05-14 20:41:58 +0000 (Thu, 14 May 2009)
Log Message:
-----------
this might work?

Modified Paths:
--------------
    trunk/nixtape/data/Group.php

Modified: trunk/nixtape/data/Group.php
===================================================================
--- trunk/nixtape/data/Group.php        2009-05-14 20:40:46 UTC (rev 1600)
+++ trunk/nixtape/data/Group.php        2009-05-14 20:41:58 UTC (rev 1601)
@@ -221,7 +221,7 @@
                        $res = $mdb2->query('SELECT g.groupname, g.owner, 
g.fullname, g.bio, g.homepage, g.created, g.modified, g.avatar_uri, 
g.grouptype, COUNT(*) AS member_count '
                                .'FROM Groups g '
                                .'LEFT JOIN Group_Members gm ON gm.grp=g.id '
-                               .'GROUP BY g.groupname, g.owner, g.fullname, 
g.bio, g.homepage, g.created, g.modified, g.avatar_uri, g.grouptype');
+                               .'GROUP BY g.groupname, g.owner, g.fullname, 
g.bio, g.homepage, g.created, g.modified, g.avatar_uri, g.grouptype ORDER BY 
gm');
                }
 
                if(PEAR::isError($res))





reply via email to

[Prev in Thread] Current Thread [Next in Thread]