Special Products Sort Order

[Becki]

Hi,

 

I want to change the sort order on specials.php from date added to either the name or model number.

 

So in specials.php I have:

 

  $specials_query_raw = "select p.products_id, pd.products_name, p.products_price, p.products_tax_class_id, p.products_image, s.specials_new_products_price from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_SPECIALS . " s where p.products_status = '1' and s.products_id = p.products_id and p.products_id = pd.products_id and pd.language_id = '" . (int)$languages_id . "' and s.status = '1' order by s.specials_date_added DESC";

 

I tried but couldn't get it right for some reason!

 

any ideas?

 

Thanks

Becki

[dp1726]

Not sure if it will help with specials but this is it one I use

http://www.oscommerce.com/forums/index.php?sho...163810&st=0

 

 

DP Glass

[Becki]

I don't know what was happening but this works now....

 

  $specials_query_raw = "select p.products_id, pd.products_name, p.products_price, p.products_tax_class_id, p.products_image, s.specials_new_products_price from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_SPECIALS . " s where p.products_status = '1' and s.products_id = p.products_id and p.products_id = pd.products_id and pd.language_id = '" . (int)$languages_id . "' and s.status = '1' order by products_name ASC";