New products in alphabetical order

[nextime]

Hallo,

I have approx 30 items in new products for: See Visit My Website

I would like to have them displayed in an alphabetical order.

I have gone through the forum, but could not find an answer.

 

Does anyone have a suggestion??

 

Thanks in advance

 

Rene

[♥geoffreywalton]

Try this

 

catalog/productsnew.php

 

has

 

$products_new_query_raw = "select p.products_id, pd.products_name, p.products_image, p.products_price, p.products_tax_class_id, p.products_date_added, m.manufacturers_name 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 = '" . (int)$languages_id . "' order by p.products_date_added DESC, pd.products_name";

 

change

 

order by p.products_date_added DESC, pd.products_name";

 

to

 

.........

[nextime]

Try this

 

catalog/productsnew.php

 

has

 

$products_new_query_raw = "select p.products_id, pd.products_name, p.products_image, p.products_price, p.products_tax_class_id, p.products_date_added, m.manufacturers_name 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 = '" . (int)$languages_id . "' order by p.products_date_added DESC, pd.products_name";

 

change

 

order by p.products_date_added DESC, pd.products_name";

 

to

 

.........

 

Hallo Geoffrey Walton,

 

Thank you for your info. Tried to make some changes there, but did not result in any change of sequense.

 

Can you help me out??

 

Thanks in advance

 

Rene