[Web-erp-svn] SF.net SVN: web-erp:[6938] trunk/SalesTypes.php

[<ex...@us...>]

Revision: 6938
          http://sourceforge.net/p/web-erp/reponame/6938
Author:   exsonqu
Date:     2014-10-25 07:08:04 +0000 (Sat, 25 Oct 2014)
Log Message:
-----------
25/10/14 Exson: Add sorting feature for tables to meet different needs.

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

Modified: trunk/SalesTypes.php
===================================================================
--- trunk/SalesTypes.php	2014-10-25 04:54:02 UTC (rev 6937)
+++ trunk/SalesTypes.php	2014-10-25 07:08:04 UTC (rev 6938)
@@ -181,13 +181,13 @@
 links to delete or edit each. These will call the same page again and allow update/input
 or deletion of the records*/
 
-	$sql = "SELECT * FROM salestypes ORDER BY typeabbrev";
+	$sql = "SELECT typeabbrev,sales_type FROM salestypes ORDER BY typeabbrev";
 	$result = DB_query($sql,$db);
 
 	echo '<table class="selection">';
 	echo '<tr>
-		<th>' . _('Type Code') . '</th>
-		<th>' . _('Type Name') . '</th>
+		<th class="ascending">' . _('Type Code') . '</th>
+		<th class="ascending">' . _('Type Name') . '</th>
 		</tr>';
 
 $k=0; //row colour counter