No one has voted on any posts yet. Votes from other community members are used to determine a member's reputation amongst their peers.
2 Posted Topics
In this query i want to display the unbooked rooms, but the booked rooms are displayed instead of the unbooked rooms... create table guest ( guest_id int auto_increment primary key unique not null, guest_lname varchar(50) not null, guest_fname varchar(50) not null, guest_email varchar(100) not null, guest_password varchar(50) not null, guest_address …
Sir what if the start date is in between but the end date is not? example room1 is booked for 4 days start date 6/14/2018, end date 6/19/2018. and the other guest search room start date on 6/18/2018, end date 6/24/2018. and i used between in my query. it means …
The End.