samedi 9 janvier 2016

How to get Current date to time

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.

enter image description here

I want to show this: Past date reservation to future reservation but current date.

enter image description here

Aucun commentaire:

Enregistrer un commentaire