What algorithm should i follow to retrieve data in the prescribed format?

Posted by Prateek on Stack Overflow See other posts from Stack Overflow or by Prateek
Published on 2014-06-05T15:14:35Z Indexed on 2014/06/05 15:24 UTC
Read the original article Hit count: 241

Filed under:
|
|

I have to retrieve data from a database in which tables are consisting of fields like "ttc, rm, atc and lta" namely. Actually these values are stored on daily basis with a 15 min interval like

From_time   to_time   ttc  rm  atc   lta 
00:00       00:15     45   10  35     25,
00:15       00:30     35   10  25     25
and so on ..

These values are stored for every day of every month and i want it to be previewed in the prescribed format then what algorithm should i follow. I am confused about how to do comparisons for a format like below mentioned. The format is at this link

https://drive.google.com/a/itbhu.ac.in/file/d/0B_J0Ljq64i4Za2J1V0lvbDZ4eGc/edit?usp=sharing

To be specific once again, my question is, I have to prepare a report from the retrieved data which is being stored in the databases as explained above. But the report which is going to be prepared will be of entire month. So, to say the least, there may be cases that for two particular days the value of "ttc" would be same for some time so i want it to be listed together (as shown in format). And the confusing part is any of the values "ttc", "rm", "atc", "lta" can be same for any particular interval. So what algorithm should i follow for such comparisons.

And if still any query with question, u can ask your doubt.

Thanks

© Stack Overflow or respective owner

Related posts about php

Related posts about mysql