Hi --

I need to find the highest and lowest entries in a field, and calculate
the difference. Can I do this with one query (mysql 4.0.2)?

I'm just getting back into php/mysql after a year's absence, so I'm sorry
if this is a basic question. I'm sure something simple is escaping me --
and will come to me as soon as this hits the server. Googled into the wee
hours with no success.

Thanks for any help --

Blue

BlueBrooke wrote:
so what have you got so far?

SELECT max( fieldname ) - min( fieldname )
FROM table

On Sat, 05 Aug 2006 11:11:59 -0500, strawberry <zac.carey (AT) gmail (DOT) com> wrote:

I had tried that, but it didn't return the value I thought it should.
There must have been another problem with it, as it's working now --

Thank you so much --

Blue