Suggestion Needed for Ticket / Inventory System...

[NoChat]

Hi all --

I'm looking to build a basic inventory system (or find one I can use
out of the box) that lets me manage tickets to an internal event at my
company. This event will take place multiple times, and there is an
allotted amount of (free) tickets for each event. I'm trying to find
something that will let me keep track of the number of available
tickets remaining for each event, and ideally something that will keep
track of who has reserved the tickets if they are not available.

Any ideas?

Thanks everyone...

 

[Adrienne Boswell]

Gazing into my crystal ball I observed NoChat <[email protected]>
writing in @k39g2000hsf.googlegroups.com:

Hi all --

I'm looking to build a basic inventory system (or find one I can use
out of the box) that lets me manage tickets to an internal event at my
company. This event will take place multiple times, and there is an
allotted amount of (free) tickets for each event. I'm trying to find
something that will let me keep track of the number of available
tickets remaining for each event, and ideally something that will keep
track of who has reserved the tickets if they are not available.

Any ideas?

Thanks everyone...

I would set up at least three tables, one for the events, one for the
tickets, and one for the ticket holders

Number of events:
SELECT COUNT(tickets.id), event_date, title, description, type, price
FROM events, tickets
WHERE event_date > getdate()
AND tickets.event_id = events.id
GROUP BY event_date, title, description, type, price

Might return:
5, 1/31/2008, Cats, See Cats, Free, 0.00
10, 2/16/2008, Dogs, See Dogs, Orchestra, 10.00

Who has tickets:
SELECT firstname, lastname, e.price, t.id
FROM tickets t, events e, holders
WHERE tickets.id = holders.ticket_id
AND events.id = tickets.event_id

Might return:
Abraham, Lincoln, 0.00, 457856
Homer, Simpson, 10.00, 457857

Not tested. You can play around with it.