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! Quote 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. Quote Link to comment https://forums.phpfreaks.com/topic/133805-mysql-booking-system/#findComment-696399 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.