On Aug 30, 2011, at 3:55 PM, Simon Spero wrote:

> On Tue, Aug 30, 2011 at 12:56 PM, Ken Irwin <[log in to unmask]> wrote:
>> I have a feeling it may be time for me to learn some grown-up programming
>> skills, and I hope someone here might be able to help.


> Sometimes it can make sense to use the database to do the aggregation; e.g.
>          SELECT inst,patron_type,item_barcode,min(date)  "first",
> min(call_no),min(renewals)  "min_renewals", max(renewals)  "max_renewals"
>                FROM Renewals
>                GROUP BY inst,patron_type,item_barcode;

Wow ... I didn't realize I was that asleep.  No wonder I had such an
unproductive day.

I'll second Simon's recommendation.  There's no reason to pull this
into PHP if you can do it all in the database, which is quite likely based
on what was described.