This module can change the display of product list .
Legend: 
Download

Report
All praise and thanks goes to Matt who helped out with the code. The attached file is the product_listing.php page with some small code changed so that when the page loads it automatically lists the products in the order they were added to the database with the newest product first.
Another code change, in the file it was taking the # of search results per page and multiplying it by 3 for this page, I eliminated the multiplier so if u want 9 items per page you get 9, not 27.
Jeze Louise... Just realized that the calling page has $sort variable (hard to miss that...) and a $HTTP_GET_VARS['sort'] of its own. Renamed variable, getvar and session var to PLsort. Everything is hunkey dorey now.
I realized that the original session variable handling is no good ($_SESSION['view']). I changed it to match my kind of ugly but otherwise functional $_SESSION['sort'] related code. Nuttin else this time.
The product_listing.php in the original submission was not functional with
the code base I use (2.2 ms2). The object references were so different as to
make me wonder if there are variations in the splitPageResults() class between
the Europe, American and Asian distributed releases.
(Something like 3 extraneous parameters were used. I'd be interested to find
out if the class implementations really DO differ.)
Changes:
1 I went back to use of the query in the splitPageResults() object
2 I altered the prep to the call of the object so that the overall shape of
the page will be similar. So, if the MAX_ is set to 10, you'll either
get 10 rows of 1 product (listing) or 10 rows of 3 (thumbnail)
3 I put the sort into the session as a failsafe (possibly sloppily, apologies.)
so that sorting will default to the previous choice during a session
regardless of whether an intermediary page kept the sort parameter or not
4 I removed the commented out original code. I didn't find it helpful.
5 I corrected some spelling mistakes and probably added a few of my own.
Apologies.
6 whatever else I forgot i did.
Good luck. Please feel free to email if you have problems. I hope you don't
have the kind of trouble I did getting this to work.
Matt
This module can change the display of product list .