I have a MySQL database which contains water quality data from sampling events. There are multiple records for each of the sample events. Each one of the records from the sample event contain the sample date and a site identification value (numeric).
What I need to do is search all of the records that exist in the database which occur on the same date with the same site identification value. Each of the water quality measurements for a given sample event, for a given site, need to be averaged. HERE IS THE QUESTION: With the information that i provided above, which scenario would be the best: 1) Create a View in MySQL 2) Use PHP to do this and store averaged values in an array I'm not very skilled in these technologies so I will need some details from your answer to get me started. Much appreciation to all who contribute to solving my problem. --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
