BrianGroce Posted November 22, 2008 Share Posted November 22, 2008 Hello All, I am designing a booking system. Users should be able to select a date from a php generated calendar and select services that are offered that day and purchase a ticket for it. The question I have: If the service is offered every saturday from now on, what should my mySQL database structure look like? Should I actually have a table and a record for every open saturday? This seams like it would be too many records... Any help would be greatly appreciated! Link to comment https://forums.phpfreaks.com/topic/133805-mysql-booking-system/ Share on other sites More sharing options...
revraz Posted November 22, 2008 Share Posted November 22, 2008 You only need one table for your "events" Yes, you need a record for each event. Link to comment https://forums.phpfreaks.com/topic/133805-mysql-booking-system/#findComment-696399 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.