[Web-erp-svn] SF.net SVN: web-erp:[7581] trunk/PcAuthorizeExpenses.php

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

Revision: 7581
          http://sourceforge.net/p/web-erp/reponame/7581
Author:   tehonu
Date:     2016-08-06 11:40:10 +0000 (Sat, 06 Aug 2016)
Log Message:
-----------
Added ORDER BY in query

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

Modified: trunk/PcAuthorizeExpenses.php
===================================================================
--- trunk/PcAuthorizeExpenses.php	2016-08-05 18:05:50 UTC (rev 7580)
+++ trunk/PcAuthorizeExpenses.php	2016-08-06 11:40:10 UTC (rev 7581)
@@ -306,7 +306,8 @@
 
 	$SQL = "SELECT tabcode,authorizer
 		FROM pctabs
-		WHERE authorizer LIKE '%" . $_SESSION['UserID'] . "%'";
+		WHERE authorizer LIKE '%" . $_SESSION['UserID'] . "%'
+		ORDER BY tabcode";
 
 	$result = DB_query($SQL);