Gnub Posted March 27, 2007 Share Posted March 27, 2007 At the moment, i have a table with a list of hotels, with 2 fields, AvailableFrom, AvailableTo. Example: Hotel: AvailableFrom: Available To: Hotel1 01/01/2007 03/03/2007 Hotel2 02/02/2007 05/05/2007 Is there a function, where i can create a temporary table, where it will hold Hotel data but instead of having AvailableFrom and AvailableTo, to hold the dates between AvailableFrom and AvailableTo. So it would then hold: Hotel: Date: Hotel1 01/01/2007 Hotel1 02/01/2007 ... Hotel1 03/03/2007 Would appreciate any help you can give, how do i accomplish such a task? Link to comment https://forums.phpfreaks.com/topic/44516-temporary-table-with-a-bite/ Share on other sites More sharing options...
effigy Posted March 27, 2007 Share Posted March 27, 2007 Why not use BETWEEN? Link to comment https://forums.phpfreaks.com/topic/44516-temporary-table-with-a-bite/#findComment-216223 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.