My database contains two fields with the Type 'Date':
The dates are in this format:
I want to return a list of all occupied dates. The problem is that March 25 is occupied and May 17 is occupied but so are all the dates in all of the dates in between!
How can I get an array containing EVERY SINGLE DATE that is occupied?
CREATE TABLE IF NOT EXISTS `rooms_reserve` (
`user_` bigint(20) NOT NULL,
`date_arrival` date NOT NULL default '0000-00-00',
`date_departing` date NOT NULL default '0000-00-00',
`activation_key` varchar(255) NOT NULL,
PRIMARY KEY (`rooms_reserve_`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=3 ;