[Web-erp-svn] SF.net SVN: web-erp:[7336] trunk/InventoryValuation.php

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

Revision: 7336
          http://sourceforge.net/p/web-erp/reponame/7336
Author:   tehonu
Date:     2015-08-10 01:43:46 +0000 (Mon, 10 Aug 2015)
Log Message:
-----------
Added ORBER BY clause

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

Modified: trunk/InventoryValuation.php
===================================================================
--- trunk/InventoryValuation.php	2015-08-05 02:41:53 UTC (rev 7335)
+++ trunk/InventoryValuation.php	2015-08-10 01:43:46 UTC (rev 7336)
@@ -247,7 +247,8 @@
 	$sql = "SELECT locations.loccode,
 					locationname
 			FROM locations
-			INNER JOIN locationusers ON locationusers.loccode=locations.loccode AND locationusers.userid='" .  $_SESSION['UserID'] . "' AND locationusers.canview=1";
+			INNER JOIN locationusers ON locationusers.loccode=locations.loccode AND locationusers.userid='" .  $_SESSION['UserID'] . "' AND locationusers.canview=1
+			ORDER BY locationname";
 
 	$LocnResult=DB_query($sql);