Ok im at my wit's end with this I have a table with four column's column a = datetime column b = decimal column c= datetime column d = datetime. column1 name = Datetime, column2 name = pH, column3 name = Startup Time, column4 name = Shutdown Time
what I have is a pH probe that is logging a pH reading every five minutes with a timestamp to look something like this reading "2006/12/29 7.543". in a mysql database The probe is hooked to a water filter which gets turned on and off a few hours a day but the pH probe never stops sending readings even when the water filter is off. so column 1 and 2 are the reading from the pH probe. column 3 is the timestamp when the water filter is turned on. and column 4 is the timestamp of when the water filter is turned off.
i need to be able to list day by day what the highest, lowest and average pH reading was when the water filter was running, then order into day to month format kinda like this
2006/12/01 Max pH 7.8 Min pH 6.8 Avg pH 7.3
2006/12/02 Max pH 6.9 Min pH 6.1 Avg pH 6.5
2006/12/03 Max PH 7.4 Min pH 6.3 Avg pH 6.8
when i go to the advanced search page i want to be able to do a between search on column 1 and list column3 and column4 values for that between search.kind like this SELECT column1 BETWEEN value="column3" & value="column4" but i need it to keep moving down column 3 and 4 to the next value till there is no more values that match that month im trying to make the report for
sorry im kinda bad at this posting stuff but if any one understands what im trying to do and can help my brain will love you
Thx Travis