[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Librefm-commits] [1026] SQL syntax correction
From: |
Toby Inkster |
Subject: |
[Librefm-commits] [1026] SQL syntax correction |
Date: |
Wed, 29 Apr 2009 22:21:13 +0000 |
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");
[Prev in Thread] |
Current Thread |
[Next in Thread] |
- [Librefm-commits] [1026] SQL syntax correction,
Toby Inkster <=