Hi, I am doing an online calendar for holiday application.
Now I got a table with these fields among many others.
req_id int(11) NOT NULL auto_increment,
req_date date NOT NULL,
username varchar(100) NOT NULL,
start_date date NOT NULL,
end_date date NOT NULL,
days_off int(11) NOT NULL,
With start_date is something like [ 1 - 10 - 2007 ] and end_date is like [ 20 - 10 -2007 ].
I am thinking whats the best way to present such data ? and how to show overlapping days between users ?
Something like:
Jan Feb
1 2 3 4 1 2 3 4 ...
+--------------------
Richard|o o o o o o o o
Fred|x x o o o o o o
Mohamed|o o o x x o o o
With HTML you could use colours to represent days/weeks off making it more apparent, eg. nothing/white for no holiday booked, and red for one booked. And if you're going to go to the day granularity, an IFRAME might be needed with left/right scrolling.
--
Richard Heyes
+44 (0)800 0213 172
http://www.websupportsolutions.co.uk
Knowledge Base and HelpDesk software
that can cut the cost of online support