[Web-erp-svn] SF.net SVN: web-erp:[6106] trunk/WWW_Users.php

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

Revision: 6106
          http://sourceforge.net/p/web-erp/reponame/6106
Author:   tehonu
Date:     2013-07-19 01:05:37 +0000 (Fri, 19 Jul 2013)
Log Message:
-----------
Added ORDER BY at salesman selection box

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

Modified: trunk/WWW_Users.php
===================================================================
--- trunk/WWW_Users.php	2013-07-18 15:04:58 UTC (rev 6105)
+++ trunk/WWW_Users.php	2013-07-19 01:05:37 UTC (rev 6106)
@@ -538,7 +538,7 @@
 		<td>' . _('Restrict to Sales Person') . ':</td>
 		<td><select name="Salesman">';
 
-$sql = "SELECT salesmancode, salesmanname FROM salesman WHERE current = 1";
+$sql = "SELECT salesmancode, salesmanname FROM salesman WHERE current = 1 ORDER BY salesmanname";
 $result = DB_query($sql,$db);
 if ((isset($_POST['Salesman']) AND $_POST['Salesman']=='') OR !isset($_POST['Salesman'])){
 	echo '<option selected="selected" value="">' .  _('Not a salesperson only login') . '</option>';