if I have a recordset that returns temperature for a year and I would like to be able to group the records into multiple buckets, one for temperature greater then 65, between 65 and 75, and greater 75 and then counting the number number of records in those buckets how would I do that in mysql? My output would look something like this
temp_range count ----------------- --------- less 65 65 65 to 75 200 greater 75 100 thanks --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "PHP & MySQL" group. To post to this group, send email to [EMAIL PROTECTED] To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/phpmysql?hl=en -~----------~----~----~----~------~----~------~--~---
