hi all, I have to program a hotel rooms availability check, with room types, price and so on. What is the best ways to store dates and availability in a MYSQL db, so that I can easily query it to get the availability? I've thought about a "day", "rooms" and "reservation" table. The last one links the other two. Any better idea ? thanks -- Oreste Attanasio oreste@xxxxxxxxxxx attanasio@xxxxxxxxx PHP Data object relational mapping generator - http://www.meta-language.net/ Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/php-objects/ <*> To unsubscribe from this group, send an email to: php-objects-unsubscribe@xxxxxxxxxxxxxxx <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/