[Web-erp-svn] SF.net SVN: web-erp:[7333] trunk/CustomerBranches.php

[<te...@us...>]

Revision: 7333
          http://sourceforge.net/p/web-erp/reponame/7333
Author:   tehonu
Date:     2015-08-04 05:58:25 +0000 (Tue, 04 Aug 2015)
Log Message:
-----------
Added ORDER BY clauses

Modified Paths:
--------------
    trunk/CustomerBranches.php

Modified: trunk/CustomerBranches.php
===================================================================
--- trunk/CustomerBranches.php	2015-08-04 03:27:51 UTC (rev 7332)
+++ trunk/CustomerBranches.php	2015-08-04 05:58:25 UTC (rev 7333)
@@ -741,7 +741,8 @@
 		$SQL = "SELECT salesmanname,
 						salesmancode
 				FROM salesman
-				WHERE current = 1";
+				WHERE current = 1
+				ORDER BY salesmanname";
 
 		$result = DB_query($SQL);
 
@@ -806,7 +807,8 @@
 		ON locationusers.loccode=locations.loccode
 			AND locationusers.userid='" . $_SESSION['UserID'] . "'
 			AND locationusers.canupd=1
-		WHERE locations.allowinvoicing='1'";
+		WHERE locations.allowinvoicing='1'
+		ORDER BY locationname";
 	$result = DB_query($SQL);
 
 	if(DB_num_rows($result)==0) {