Problem with database query |
@InsiteFX, $temp return this:
Quote:SELECT * FROM `rooms` LEFT JOIN `reservations` ON `rooms`.`id` = `reservations`.`room_id` and `reservations`.`date` = '2019-05-29' and `reservations`.`time_start`<='10:00' and `reservations`.`time_finish`>='13:00' WHERE reservations.id IS NULL @php_rocs, yes. Reservations are only for one day. |
Messages In This Thread |
Problem with database query - by mizkuskuz - 05-29-2019, 02:47 AM
RE: Problem with database query - by InsiteFX - 05-29-2019, 08:27 AM
RE: Problem with database query - by php_rocs - 05-29-2019, 08:54 AM
RE: Problem with database query - by mizkuskuz - 05-29-2019, 10:06 AM
|