Largest row in an array

Posted: Thu Oct 21, 2010 8:31 pm

OOOOooo Great Guru's

Humble Grasshopper is STUCK!

Here is the Problem...

UserA-Z has a bunch of #1 widgets, #2 widgets and #3 widgets...for each User I need to find the largest #1 widget, Largest #2 widget and Largest #3 widget and then (This is where I get lost...) adding the weight of #1, #2 and #3 for the total weight of all three types of widgets.

I have them out of the data base...
User A - Largest #1-1 lb
User B - Largest #1- 10 lb
User C - Largest #1- 6 lb

and have converted them into an array.
TS,UID,Widget1, weight
(TS is the record number)

How do I compare those arrays to find out which one (row[3] more or less) is the greatest?

I am not looking for anyone to write code for me...just a nudge in the right direction or a link to an example will be fine. I am just having a hard time wrapping my head around this one.

Thank You for your time!!

Dawg

Posted: Fri Oct 22, 2010 12:39 am

walk through each recursively with foreach?

registered · Posted: Fri Oct 22, 2010 5:48 pm

There are always many ways to accomplish the same goal. I always tend to think of how I can make the database do most of the heavy lifting for me. Since I don't know your exact table structure and what these Widgets are, I can't tell you for sure. But, I suspect that it might be possible to write a SELECT within a SELECT where the inner SELECT returns the max weight for each user/widget combination and then the outer SELECT uses that result and SUMS the weights for each user.

Posted: Wed Oct 27, 2010 6:24 am

Guys thank you for your help!

Sorry for the late reply...I was off working.

What I wound up doing was creating a new table called big widget and every time a widget was added...and it was larger than the existing widget....that table got updated.

Dawg