I was wondering if that same thing is possible if I have two columns in my table
"date_from" and "date_to" instead of just one column "date_booked" .
So, is there anyway we can get the dates of all the 8 rooms that are booked for the dates between "date_from" and "date_to".
Here is the table DDL
CREATE TABLE `orders` (
`orderID` int(10) NOT NULL AUTO_INCREMENT,
`user_id` int(10) DEFAULT NULL,
`room_id` int(10) DEFAULT NULL,
`date_from` date DEFAULT NULL,
`date_to` date DEFAULT NULL,
PRIMARY KEY (`orderID`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=latin1 COMMENT=''
Any help is appreciated.