Hello i want to create a Query that i can see the date inicial and date final when i see today data and the future reservation for the => today
SELECT DISTINCT idreserva AS id, hora_inicial, data_inicial, cliente_idcliente,
num_pessoas_adultas, num_pessoas_crianca,
mesa_numero, hora_final, data_final
FROM reserva,
reserva_has_mesa,
cliente
WHERE cliente_idcliente = '%s'
AND ativo = '1'
AND reserva_idreserva = idreserva
AND ( (reserva.data_inicial = \"".$data."\"
AND reserva.hora_inicial>=\"".$intervaloTempo."\" )
OR reserva.data_inicial > \"".$data."\")
AND ( (reserva.data_final = \"".$data."\"
AND reserva.hora_final>=\"".$intervaloTempo."\")
OR reserva.data_final > \"".$data."\")
Current problem - Showing the all reservations and show repetead reservation and reservation that pass the current date.
I want to show this: Past date reservation to future reservation but current date.
Aucun commentaire:
Enregistrer un commentaire