Web Hosting : php/mysql seating chart

Hostgator and Bluehost are our best webhosts and godaddy.com is the best domain registrar.

This web hosting thread started by cnapsys on 9 September 2008

I’m working on a rather complex system and I cant figure out the best approach:
This is for an online ticket selling system.
I’m currently working on the inventory module.

I have several seating charts from several venues.

The seating charts break down into:
1) Zone
2) Rows in current zone
3) Assigned seats on each row

E.g.
Zone A has 10 rows. Each row has a specific number of seats.

R1: 1,2,3,4,5,6,7,8,9,10,11,12,13,14,15
R2: 1,2,3,4,5,6,7,8,9,10,11,12,13,14
.
.
.
R10: 1,2,3,4,5,6,7,8,9,10,11,12

Here’s what I’m thinking:

Option 1.
Have a table for each zone based on the # of rows and for each row build an array with the seats.

Option 2.
Have a preset table with a larger number of rows and seats and mark them with 1 for valid 0 for invalid

Let me know if there is a better approach or if you have any suggestion on how this should be done.

I’m trying to make it as simple as possible for the vendors/organizers that will have an event at one of the venues that I have the seating chart for. However, there will be events at other venues that I will not have the seating chart and I’m trying to figure out a solution that will work for those as well.

Any tips/suggestions would be greatly appreciated

Discuss this at WHT or read more about bluehost and hostgator