[Web-erp-svn] SF.net SVN: web-erp:[6045] trunk/SelectCustomer.php

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

Revision: 6045
          http://sourceforge.net/p/web-erp/reponame/6045
Author:   tehonu
Date:     2013-07-03 08:03:25 +0000 (Wed, 03 Jul 2013)
Log Message:
-----------
Added ORDER BY clause

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

Modified: trunk/SelectCustomer.php
===================================================================
--- trunk/SelectCustomer.php	2013-07-03 07:52:48 UTC (rev 6044)
+++ trunk/SelectCustomer.php	2013-07-03 08:03:25 UTC (rev 6045)
@@ -305,7 +305,7 @@
 		<td>';
 if (isset($_POST['CustType'])) {
 	// Show Customer Type drop down list
-	$result2 = DB_query("SELECT typeid, typename FROM debtortype", $db);
+	$result2 = DB_query("SELECT typeid, typename FROM debtortype ORDER BY typename", $db);
 	// Error if no customer types setup
 	if (DB_num_rows($result2) == 0) {
 		$DataError = 1;