#
#
# patch "www/index.php"
#  from [bf19152ac68e86ba765111583b98ed3c71a5a7a1]
#    to [189fa1cdee7ed126cea34def7312b03b29a5968d]
#
============================================================
--- www/index.php	bf19152ac68e86ba765111583b98ed3c71a5a7a1
+++ www/index.php	189fa1cdee7ed126cea34def7312b03b29a5968d
@@ -48,8 +48,7 @@ if ($validuser) {
 # First, display those maintained by the logged in user, if any
 $projcnt = 0;
 if ($validuser) {
-#	$query = "SELECT name, directory FROM projects WHERE name IN (SELECT project FROM permissions WHERE username = '%s')";
-	$query= "SELECT name FROM projects WHERE name IN (SELECT project FROM permissions WHERE username=?)";
+	$query= "SELECT name FROM projects WHERE name IN (SELECT project FROM permissions WHERE username=?) ORDER BY name";
 	$result = $db->Execute($query, array($username));
 	if (!$result) {
 		printf("<b>ERROR</b>");
@@ -65,8 +64,7 @@ if ($validuser) {
 		}
 	}
 
-#	$query = "SELECT name, directory FROM projects WHERE name NOT IN (SELECT project FROM permissions WHERE username = '%s')";
-	$query = "SELECT name FROM projects WHERE name NOT IN (SELECT project FROM permissions WHERE username=?)";
+	$query = "SELECT name FROM projects WHERE name NOT IN (SELECT project FROM permissions WHERE username=?) ORDER BY name";
 	$result = $db->Execute($query, array($username));
 	if (!$result) {
 		printf("<b>ERROR</b>");
@@ -81,7 +79,7 @@ if ($validuser) {
 		}
 	}
 } else {
-	$query = "SELECT name FROM projects";
+	$query = "SELECT name FROM projects ORDER BY name";
 	$result = $db->Execute($query);
 	if (!$result) {
 		printf("<b>ERROR</b>");