Hi, I wonder if it is possible to ADD the Sorting Option Box (dates, manufacturers,prices etc.) on to the Product Listings page?

I tried to edit the product listing module but it never worked out...



Quote Originally Posted by yellow1912 View Post
That was a mistake I made. Notice the "disp_order_default " ? You can change. And the code below will use products all sort default(PRODUCT_ALL_LIST_SORT_DEFAULT), you can use a different one of course.
PHP Code:
<?php
/**
 * products_all  header_php.php
 *
 * @package page
 * @copyright Copyright 2003-2006 Zen Cart Development Team
 * @copyright Portions Copyright 2003 osCommerce
 * @license http://www.zen-cart.com/license/2_0.txt GNU Public License V2.0
 * @version $Id: header_php.php 4261 2006-08-25 04:35:20Z ajeh $
 */

  
require(DIR_WS_MODULES zen_get_module_directory('require_languages.php'));

  
$breadcrumb->add(NAVBAR_TITLE);
// display order dropdown
$disp_order_default PRODUCT_ALL_LIST_SORT_DEFAULT;
  require(
DIR_WS_MODULES zen_get_module_directory(FILENAME_LISTING_DISPLAY_ORDER));


  
$listing_sql "SELECT p.products_type, p.products_id, pd.products_name, p.products_image, p.products_price, p.products_tax_class_id,
                                    p.products_date_added, m.manufacturers_name, p.products_model, p.products_quantity, p.products_weight, p.product_is_call,
                                    p.product_is_always_free_shipping, p.products_qty_box_status
                             FROM " 
TABLE_PRODUCTS " p
                             LEFT JOIN " 
TABLE_MANUFACTURERS " m ON (p.manufacturers_id = m.manufacturers_id), " TABLE_PRODUCTS_DESCRIPTION " pd
                             WHERE p.products_status = 1
                             AND p.products_id = pd.products_id
                             AND pd.language_id = :languageID " 
$order_by;

  
$listing_sql $db->bindVars($listing_sql':languageID'$_SESSION['languages_id'], 'integer');
 
//check to see if we are in normal mode ... not showcase, not maintenance, etc
  
$show_submit zen_run_normal();

$define_list = array('PRODUCT_LIST_MODEL' => PRODUCT_LIST_MODEL,
  
'PRODUCT_LIST_NAME' => PRODUCT_LIST_NAME,
  
'PRODUCT_LIST_MANUFACTURER' => PRODUCT_LIST_MANUFACTURER,
  
'PRODUCT_LIST_PRICE' => PRODUCT_LIST_PRICE,
  
'PRODUCT_LIST_QUANTITY' => PRODUCT_LIST_QUANTITY,
  
'PRODUCT_LIST_WEIGHT' => PRODUCT_LIST_WEIGHT,
  
'PRODUCT_LIST_IMAGE' => PRODUCT_LIST_IMAGE);

  
/*                         ,
  'PRODUCT_LIST_BUY_NOW' => PRODUCT_LIST_BUY_NOW);
  */
  
asort($define_list);
  
reset($define_list);
  
$column_list = array();
  foreach (
$define_list as $key => $value)
  {
    if (
$value 0$column_list[] = $key;
  }
?>