jacomus Posted April 23, 2008 Share Posted April 23, 2008 I am just wondering for a booking system that will require hundreds of items which will be booked for multiple dates... Will I have to create a table for each of the items or is there a method by which I can create a single table with all of the items in one column and all of the booking dates in the rows beside each item? Link to comment https://forums.phpfreaks.com/topic/102509-solved-question-on-a-booking-system/ Share on other sites More sharing options...
fenway Posted April 23, 2008 Share Posted April 23, 2008 Well, not "beside".... simply have each row contain an item_uid which points to items in another table. Then have a bookings table with the start/end dates. Link to comment https://forums.phpfreaks.com/topic/102509-solved-question-on-a-booking-system/#findComment-524851 Share on other sites More sharing options...
jacomus Posted April 23, 2008 Author Share Posted April 23, 2008 Thanks, I wasn't even considering something along those lines. Much appreciated =) Link to comment https://forums.phpfreaks.com/topic/102509-solved-question-on-a-booking-system/#findComment-524871 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.