Sorting numbers in Categories/Products

[fateimport]

Sorry for all the questions lately, but everyone has been such a big help. I have a question about sorting numbers (years) in the categories/product. I guess by default it lists numbers least to greatest, top to bottom.

http://www.fateimport.com/store/inde...=24_59_73_1006[url]

Is it possible to change it so the greatest starts from the top?

I may have found an answer in the forum archive, but it's one big, long paragraph message that I can't tell what's code and what's not, what's top and what's bottom. haha. It was too confusing for me.

thanks

[fateimport]

I looked at what I thought was the answer to sorting products, but my product_info looks different than what was posted:

http://www.oscommerce.com/community/contributions,1822[url]

Mine looks like this:

$product_check_query = tep_db_query("select count(*) as total from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd where p.products_status = '1' and p.products_id = '" . (int)$HTTP_GET_VARS['products_id'] . "' and pd.products_id = p.products_id and pd.language_id = '" . (int)$languages_id . "'");
$product_check = tep_db_fetch_array($product_check_query);

Any advice or help?

Thanks

[fateimport]

Don't know why the link isn't going to the right place, but I'll try again. The post is:

http://www.oscommerce.com/community/contributions,1822

It's about sorting categories. The php looks different than mine (message above), so I don't know if this applies to me.

I want to be able to sort years from most recent on top to older on the bottom.

Does anyone have the answer for this?

[ph1ngering]

you can sort rank the catagories.. It will take some time but would work for you..

When you edit a catagory at the bottom is has a box for sort order.

If you put a 1 in the box it would put it at the top of the list.. So if you manually edit all your years you would be able to get them in the reverse order.. 1,2,3,4,5.. and so on...

Hope this helps...

Thanks
--Craig