From 713832f351a053ed580a59e49fbc3e504ddd869c Mon Sep 17 00:00:00 2001 From: kkalev Date: Sun, 24 Nov 2002 15:08:20 +0000 Subject: [PATCH] We don't need ORDER BY GroupName in show_groups.php3 since we have GROUP BY --- Changelog | 1 + htdocs/show_groups.php3 | 2 +- 2 files changed, 2 insertions(+), 1 deletion(-) diff --git a/Changelog b/Changelog index 5a157b6..aa2b0ea 100644 --- a/Changelog +++ b/Changelog @@ -8,6 +8,7 @@ Ver 1.62: * Fix a typo in sql.attrmap. Fix by Evren Yurtesen * Work even when register_globals if off. Suggestion from Evren Yurtesen Also add an entry in the FAQ about that. +* We don't need ORDER BY GroupName in show_groups.php3 since we have GROUP BY Ver 1.61: * Add a string encoder for greek * If general_decode_normal_attributes is set then encode attributes in lib/ldap/change_info. In the near future diff --git a/htdocs/show_groups.php3 b/htdocs/show_groups.php3 index 4a9251f..02edd96 100644 --- a/htdocs/show_groups.php3 +++ b/htdocs/show_groups.php3 @@ -56,7 +56,7 @@ EOM; $link = @da_sql_pconnect($config); if ($link){ $search = @da_sql_query($link,$config, - "SELECT COUNT(*),GroupName FROM usergroup Group by GroupName ORDER BY GroupName;"); + "SELECT COUNT(*),GroupName FROM usergroup GROUP BY GroupName;"); if ($search){ if (@da_sql_num_rows($search,$config)){ while( $row = @da_sql_fetch_array($search,$config) ){ -- 2.39.5