Welcome Guest, Not a member yet? Register   Sign In
Problem with database query
#4

(This post was last modified: 05-30-2019, 01:09 AM by mizkuskuz.)

@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.
Reply


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



Theme © iAndrew 2016 - Forum software by © MyBB