create a calendar with month view
Hi,
I would like to know how I can create a calendar month view and populate my records into the relevant boxes.
My database:
CREATE TABLE IF NOT EXISTS `jobs` (
`job_id` int(8) NOT NULL auto_increment,
`job_day` varchar(10) collate utf8_unicode_ci NOT NULL,
`job_date` varchar(10) collate utf8_unicode_ci NOT NULL,
`job_start_time` varchar(10) collate utf8_unicode_ci NOT NULL,
`job_finish_time` varchar(10) collate utf8_unicode_ci NOT NULL,
`job_gross_hrs` varchar(6) collate utf8_unicode_ci NOT NULL,
`job_break_hrs` varchar(6) collate utf8_unicode_ci NOT NULL,
`job_total_hrs` varchar(6) collate utf8_unicode_ci NOT NULL,
`job_job_role` varchar(255) collate utf8_unicode_ci NOT NULL,
`job_got_signature` varchar(5) collate utf8_unicode_ci default NULL,
`job_mileage` varchar(20) collate utf8_unicode_ci default NULL,
`client_id` varchar(8) collate utf8_unicode_ci NOT NULL,
`staff_id` varchar(8) collate utf8_unicode_ci default NULL,
PRIMARY KEY (`job_id`),
KEY `client_id` (`client_id`),
KEY `staff_id` (`staff_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;
I know my job_date is not in DATE format, that is due to my lack of knowledge of how to use DATE functions
I would ideally like to use a grid to display the date and the jobs within it.
