Query Select from table

Vote count:

0

I'm working on a project about hotel room reservations.

I have 4 tables :

Rooms ( room_id, category, price);

booking_rooms (idbr, room_id, booking_id);

bookings (booking_id,client_id, checkin, checkout);

clients(client_id, fistname,lastname, address,phone,email);

I want to create a search form to check available rooms between checkin and checkout date and category too.

SELECT * FROM rooms WHERE room_id NOT IN (select room_id from bookings_rooms WHERE (checkin < '$checkindate' AND checkout > '$checkoutdate') or (checkin> '$checkindate' AND checkin< '$checkindate'))

This is what I did. And it's not working.

Can you guys help me with this. Can you give me an ideea ?

asked 30 secs ago

Claudiu Lacatusu

1

Query Select from table