I use this code to change the order of all of the categories as they display on the menu to be by date added.
$listing_sql .= " order by p.products_date_added DESC, pd.products_name";

The category products are displaying showing the newest first. But i have a problem.

When i click in "Item Name" to be list by Name and to replaced the second option. The list continue showing by date added?

Do you understand-me. I´m Brazilian and my English is not good.

Can you help-me?