Error: 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 'AND BPHTL_bookingRooms.status='approved' ORDER BY BPHTL_bookingRooms.arrival_dat' at line 1
Error No: 1064
SELECT *, as bookid FROM BPHTL_bookings JOIN BPHTL_bookingRooms ON = BPHTL_bookingRooms.booking_id WHERE BPHTL_bookingRooms.arrival_date >= CURRENT_DATE() AND BPHTL_bookings.customer_id = AND BPHTL_bookingRooms.status='approved' ORDER BY BPHTL_bookingRooms.arrival_date ASC

My Bookings

Select Booking to SEE WHO HAS SIGNED IN

Online check-in

All guests visiting the estate MUST check-in prior to arrival. You cannot sign in for any adult other than your self so please share the link!
Select the estate home at which you're checking in..

*In some RARE cases, guests don't want their friends & family to know WHERE they're going/staying (i.e. if it's a surprise trip)...
If this applies to you, please click one of the alternate* links below to PRINT OUT copies of the check-in waiver to have your guests sign upon arrival.
(You may also find this useful if you have guests in your party who absolutely do not have a computer, tablet, or smartphone to sign in at the links above)...