populate table column based on timestamp

[elp09bm]

Dear All

 

I want to display my data in tabular columns with the headings of table  like 00:06-00:08,00:08-00:10,00:10:00:12:00........22:00-24:00.i.e.time

In database I have two columns one containing value and other containing time when this reading was done.

I could retrieve data from my mysql table in php and look at time.

I want to know how could I insert the value to the correct column of table based on the time.

e.g If I have record in table in database say containing value 09:45 and 5.

I want this value to go to the column heading 00:08-00:10 and same thing for the other values.

 

I hope I am clear with the problem definition but if you need more info.Please let me know.

 

Thanks,

elp