hi guys, Ive started using Zend Db Table Relationships now for grabbing all my data, but i have a question:
My db has properties, tenants, and accounts
each property has a tenant
each tenant has several months worth of accounts
i'm trying to grab everything in order of money owed
so i fetch properties,
and foreach i grab the current tenant and then grab the accounts for that tenant
but i need to sort all the properties by the tenant who owes the most, and im not sure how to do that from a zend rowset thats already been fetched. any ideas?