[Librefm-commits] [1026] SQL syntax correction

[Toby Inkster]

Revision: 1026
          http://svn.sv.gnu.org/viewvc/?view=rev&root=librefm&revision=1026
Author:   tobyink
Date:     2009-04-29 22:21:12 +0000 (Wed, 29 Apr 2009)
Log Message:
-----------
SQL syntax correction

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

Modified: trunk/nixtape/data/Group.php
===================================================================
--- trunk/nixtape/data/Group.php        2009-04-29 22:16:53 UTC (rev 1025)
+++ trunk/nixtape/data/Group.php        2009-04-29 22:21:12 UTC (rev 1026)
@@ -113,7 +113,7 @@
        static function groupList ()
        {
                global $mdb2;
-               $res = $mdb2->query("SELECT g.groupname, g.owner, g.fullname, 
g.bio, g.homepage, g.created, g.modifed, g.avatar_uri, g.grouptype, COUNT(*) AS 
gm.member_count "
+               $res = $mdb2->query("SELECT g.groupname, g.owner, g.fullname, 
g.bio, g.homepage, g.created, g.modifed, g.avatar_uri, g.grouptype, COUNT(*) AS 
member_count "
                        ."FROM Groups g "
                        ."LEFT JOIN Group_Members gm ON 
gm.groupname=g.groupname "
                        ."GROUP BY g.groupname, g.owner, g.fullname, g.bio, 
g.homepage, g.created, g.modifed, g.avatar_uri, g.grouptype");