I have a membership site and users can upgrade to premier.
When they upgrade to Premier an invoice is created and their Premier status is set to 1. Now, when displaying a list of users I want to ORDER them first according to Premier Status, then based on the date they became Premier. The date they became Premier is in the invoice. So how can I reference this date?
I know this question is a bit confusing, but if anyone can help I would really appreciate it.
try adding a new field in the members table, name it premier_time and make it the same as premier_time in the invoices table... that would then when they sign up, have it add to both fields.. thats probably the way i would do it..