westkoast Posted July 10, 2003 Share Posted July 10, 2003 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? I need to read the rules more often... Link to comment Share on other sites More sharing options...
westkoast Posted July 10, 2003 Author Share Posted July 10, 2003 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... I need to read the rules more often... Link to comment Share on other sites More sharing options...
Guest Posted July 10, 2003 Share Posted July 10, 2003 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 Link to comment Share on other sites More sharing options...
westkoast Posted July 11, 2003 Author Share Posted July 11, 2003 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... I need to read the rules more often... Link to comment Share on other sites More sharing options...
westkoast Posted July 11, 2003 Author Share Posted July 11, 2003 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. I need to read the rules more often... Link to comment Share on other sites More sharing options...
Guest Posted July 11, 2003 Share Posted July 11, 2003 order by sort_order desc Good luck, Matt Link to comment Share on other sites More sharing options...
westkoast Posted July 11, 2003 Author Share Posted July 11, 2003 order by sort_order desc Good luck, Matt Yeah, you nailed it. SORT BY col_name DESC Thanks everyone!! I need to read the rules more often... Link to comment Share on other sites More sharing options...
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.