Cita: SELECT RES_HAB FROM RESERVAS WHERE RES_FINI>='2009-08-04 13:00:00' AND RES_FEND<='2009-08-04 12:00:00' AND RES_HOT=1
La condición no se cumple con los datos que pones.
Prueba esta:
Código sql:
Ver originalSELECT RES_HAB FROM RESERVAS WHERE RES_FINI>='2009-08-04 13:00:00' AND RES_FEND<='2009-08-07 12:00:00' AND RES_HOT=1