problem with date-funktion

From: (wrong string) äfer <schaeferpatrick_at_gmx.de>
Date: Tue, 11 Feb 2003 17:43:09 +0100
Message-ID: <3e4927f5$0$28053$9b622d9e_at_news.freenet.de>

Hallo,
[Quoted] i have a problem:

[Quoted] i have a database table, that includes all dates, when a hotelroom is taken. example.

for room number 1 (is taken)

1    2003-03-02 - 2003-03-20
1    2003-03-25 - 2003-03-28
1    2003-04-10 - 2003-04-15

.
.
.

who can i create a table that describe when room number 1 is not taken? like for example

1    -                      2003-03-02
1    2003-03-20 - 2003-03-25

1 2003-03-28 - 2003-04-10
1 2003-04-15 -

thank you for your help Received on Tue Feb 11 2003 - 17:43:09 CET