good day experts!! i would like to ask why do i get this error?
in mysql query browser it says:SELECT tbl_rooms.*,tbl_cottage_number.*,tbl_cottage_type. *,tbl_room_number.* FROM tbl_rooms,tbl_cottage_number,tbl_cottage_type,tbl_ room_number WHERE tbl_rooms.FK_cottage_type=tbl_cottage_type.PK_cott age_type_id AND tbl_rooms.FK_cottage_number=tbl_cottage_number.PK_ cottage_number_id AND tbl_rooms.FK_room_number=tbl_room_number.PK_room_n umber_id AND tbl_cottage_type.PK_cottage_type_id = 1 AND tbl_rooms.PK_room_id NOT IN (SELECT tbl_booking.FK_rooms FROM tbl_booking WHERE (tbl_booking.check_in_date <= '2008-01-07 08:00:00' AND tbl_booking.check_out_date BETWEEN '2008-01-07 08:00:00' AND '2008-01-08 07:50:00') OR (tbl_booking.check_in_date BETWEEN '2008-01-07 08:00:00' AND '2008-01-08 07:50:00' AND tbl_booking.check_out_date <= 2008-01-08 07:50:00))
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '07:50:00))' at line 1
please help me correct my syntax.. thanks!!