populate table column based on timestamp

PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!

Moderator: General Moderators

Post Reply
elp09bm
Forum Newbie
Posts: 1
Joined: Wed Apr 06, 2011 10:02 am

populate table column based on timestamp

Post by 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
Post Reply