Posted by Ciaran on 12/01/07 11:00

On Dec 1, 10:43 am, "Shelly" <sheldonlg.n...@asap-consult.com> wrote:
> Ciaran wrote:
> > I have a result resource from a large mysql query and I need to find
> > the single the highest value from a certain field. What's the best way
> > to pull it off?
> > Cheers,
> > Ciarán
>
> A simple google of "sql max" would have led you to:
> SELECT MAX(expression )
> FROM tables
> WHERE predicates;
>
> --
>
> Shelly

Thanks Shelly but I'm not great with sql and my query is already huge.
I don't think I'll be able to modify it to include the max as well as
everything else. Not to worry - I'm going to split the results into a
3d array and then try to sort it with php.
Thanks for the help

[Back to original message]