[php] Kalenderabfrage

[Lutz Zetzsche]

Hi Eric,

Eric Binek schrieb:
> SELECT
> 	*
>  FROM
> 	zimmerbelegung
> WHERE
> 	(zimmer=101 AND (DATE_SUB(CURDATE(),INTERVAL 30 DAY) <= date_col))
> 	OR
> 	(zimmer=102 AND (DATE_SUB(CURDATE(),INTERVAL 30 DAY) <= date_col))
> 	OR
> 	(zimmer=103 AND (DATE_SUB(CURDATE(),INTERVAL 30 DAY) <= date_col))

WHERE
zimmer IN (101,102,103) AND (DATE_SUB(CURDATE(),INTERVAL 30 DAY) <= date_col)

ist kürzer. :-)


Viele Grüße

Lutz