|
Posted by J.O. Aho on 06/13/11 11:37
Thoren wrote:
> Hi,
>
> I need to do a planning (monday - sunday) with some jobs during 1 hour.
>
> How could I build the tables ?
I think I would make a table with at least the following columns
start_time (int(unixtime)) | end_time (int(unixtime)) | description (varchar)
Why use unixtime?
php has quite good function to convert those easily to other formats like day
name, week, hour. It's enough to fetch the data from one column in the table
for many things to display.
//Aho
Navigation:
[Reply to this message]
|