Back again with another client request.

My client want to have the customers orders displayed sorted with the latest order on top of the list of orders when a customer logs into their account. She says the latest order now appears at the bottom of the list of orders in the customers view after logging in.

How/where do I change the cart to make the most recent order appear on the top of the customer view list with the list of orders sorted by the order date?

As always, thanks in advance for any help.

Ray Cramblit

Hi Ray,
open vsadmin/inc/incclientlogin.php and around line 918

$sSQL="SELECT ordID,ordDate,ordTrackNum,ordTotal,ordStateTax,ordCountryTax,ordShipping,ordHSTTax,ordHandling,ordDiscount," . getlangid('statPublic',64) . " FROM orders LEFT OUTER JOIN orderstatus ON orders.ordStatus=orderstatus.statID WHERE ordStatus<>1 AND ordClientID=" . $_SESSION['clientID'] . " ORDER BY ordDate";

Just add DESC so it reads
" ORDER BY ordDate DESC";



* Database Migrations and Conversions*
* ASP to PHP Cart Conversions*
*Contact Us*
*Buy The PHP Capture Card Plugin*
*Rate Our Services/View Our Feedback*

Hi Ray, I know Phil really knows his stuff, and I don't want to contradict his response, and maybe I don't fully understand the questions, but when you list orders in the admin, you can change the sort by clicking any of the headings there.
Click (Date) once for descending and again for ascending.

At least I think that's what you want.

Thanks,
David

It was the "when a customer logs into their account" that pointed me in the right direction.



* Database Migrations and Conversions*
* ASP to PHP Cart Conversions*
*Contact Us*
*Buy The PHP Capture Card Plugin*
*Rate Our Services/View Our Feedback*

Ahhh... Epic fail on my part..
I guess I just glossed over the question.

Good one.

Thanks,
David

BIG Thanks Phil!

Someday I'll be as smart as the moderators of this forum!

Ray Cramblit