Get smallest value from a field in an array

[ncardoso]

Hi all,

I have a returned array from an SQL statement. That array contains 5 fields (columns). One of those is called totalResults. In my sql statement, I retrieve Min, Max and Avg info from that field for each user through my sql statement and Group By. Now I need to get the lowest number in the totalResults field in that entire array not just for one person.

Ideas? Do I do it using PHP?... or do I make another call to the mysql db without the group by?

Thanks a million
Nelson Cardoso

[stolzyboy]

the best solution would be to use msyql to do it, it is faster to do it that way to get results