[prev in list] [next in list] [prev in thread] [next in thread] 

List:       tep-commits
Subject:    [TEP-COMMIT] CVS: admin/admin products_attributes.php,1.46,1.47
From:       "Thomas A. Moulton" <thomasamoulton () users ! sourceforge ! net>
Date:       2002-10-15 15:12:38
[Download RAW message or body]

Update of /cvsroot/tep/admin/admin
In directory usw-pr-cvs1:/tmp/cvs-serv15358/admin/admin

Modified Files:
	products_attributes.php 
Log Message:
Enhance SQL code so that the products that have attributes defined
are displayed in alphabetical order so admin's can find them a lot
easier.


Index: products_attributes.php
===================================================================
RCS file: /cvsroot/tep/admin/admin/products_attributes.php,v
retrieving revision 1.46
retrieving revision 1.47
diff -u -d -r1.46 -r1.47
--- products_attributes.php	11 Jun 2002 16:30:21 -0000	1.46
+++ products_attributes.php	15 Oct 2002 15:12:35 -0000	1.47
@@ -560,7 +560,7 @@
             <td colspan="7" class="smallText">
 <?php
   $per_page = MAX_ROW_LISTS_OPTIONS;
-  $attributes = ("select * from " . TABLE_PRODUCTS_ATTRIBUTES . " order by \
products_attributes_id"); +  $attributes = "select pa.* from " . \
TABLE_PRODUCTS_ATTRIBUTES . " pa left join " . TABLE_PRODUCTS_DESCRIPTION . " pd on \
pa.products_id = pd.products_id and pd.language_id = '" . $languages_id . "' order by \
pd.products_name";  if (!$attribute_page) {
     $attribute_page = 1;
   }



-------------------------------------------------------
This sf.net email is sponsored by:ThinkGeek
Welcome to geek heaven.
http://thinkgeek.com/sf
_______________________________________________
Tep-commits mailing list
Tep-commits@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/tep-commits


[prev in list] [next in list] [prev in thread] [next in thread]