Products show up in alpabetical order - how to do reverse??

[westkoast]

Our products are labeled with the date ex 06/03...

 

We want the newest ie 06/03 to be above 03/03, but because OSC does alpabetical order the older products are show up above the newer ones.

 

Is there any way to do a reverse printout of the list?

[westkoast]

Ok, I've tried looking at the includes/boxes/boxname.php and I can't seem to figure out how to do reverse alphabetical order.

 

Is this something that can be done with the mysql phpadmin? Like set up the database so it spits out the info backwards...

[Guest]

Which list? What filename is in the url? E.g. default.php, index.php, product_info.php, etc. Is this in an InfoBox? Which one? E.g. New Products, Featured Products, etc. A link wouldn't hurt if it's possible.

 

Thanks,

Matt

[westkoast]

Which list? What filename is in the url? E.g. default.php, index.php, product_info.php, etc. Is this in an InfoBox? Which one? E.g. New Products, Featured Products, etc. A link wouldn't hurt if it's possible.

 

Thanks,

Matt

 

Unfortunatly the box is password protected. I coded the right side so the boxes on the right only show when a user is logged in.

 

Basically what the box does is this:

I have a folder on the backend named "physicians only" it is ID 22.

 

I edited the "products box" to only list products from ID 22 (the physicians folder). Which works great, but I can't figure out how to list those products in reverse order...

[westkoast]

order by sort_order

 

Ok, I found this in the $categories_query = tep_db_query().

 

What should "sort_order" read so that it sorts by highest->lowest, instead of lowest->highest.

[Guest]

order by sort_order desc

Good luck,

Matt

[westkoast]

order by sort_order desc

Good luck,

Matt

 

Yeah, you nailed it. SORT BY col_name DESC

 

Thanks everyone!!