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
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
