I have a problem, i have a table, where the information of some devices are deposited if they have an alert, the structure of the table is this:
ID | SERVERID | TEMP | SENSOR | PROCESSED | DATETIME
1 | 12458788 | 23.3 | 1 | 0 |2012-01-16 16:50:01
I need to send the information to another table, if i have 3 records in 1 hour, the script sends only 1 record to another table or 2 followed records = 1 record in another table , do you have some ideas? i really really need help!
Thank for your time!!
The table populates with various SERVERID's in an hour.....i need to send 1 record to another table for every 3 records in an hour of every serverid..... Thanks!!