Suggestion Needed for Ticket / Inventory System...

Discussion in 'ASP General' started by NoChat, Jan 14, 2008.

  1. NoChat

    NoChat Guest

    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...
     
    NoChat, Jan 14, 2008
    #1
    1. Advertising

  2. Gazing into my crystal ball I observed NoChat <>
    writing in news:189abbbd-9ae1-4235-84c6-97c54c690692
    @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.

    --
    Adrienne Boswell at Home
    Arbpen Web Site Design Services
    http://www.cavalcade-of-coding.info
    Please respond to the group so others can share
     
    Adrienne Boswell, Jan 14, 2008
    #2
    1. Advertising

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Inventory in ASP.

    , Jan 21, 2006, in forum: ASP .Net
    Replies:
    1
    Views:
    3,110
    =?Utf-8?B?RWx0b24gVw==?=
    Jan 21, 2006
  2. David Tuman

    directory inventory

    David Tuman, Feb 10, 2004, in forum: C++
    Replies:
    3
    Views:
    438
    Christoph Rabel
    Feb 10, 2004
  3. lalalala

    inventory databasing

    lalalala, May 26, 2006, in forum: Java
    Replies:
    1
    Views:
    823
    IchBin
    May 26, 2006
  4. Lisa Fong
    Replies:
    0
    Views:
    361
    Lisa Fong
    Feb 16, 2007
  5. =?Utf-8?B?UGF1bCBCdXp6YSwgb2xkc3RlciB1c2luZyBuZXcg

    Print Label on LOCAL Zebra Printer from WEBSITE Inventory DB

    =?Utf-8?B?UGF1bCBCdXp6YSwgb2xkc3RlciB1c2luZyBuZXcg, Apr 25, 2007, in forum: ASP .Net
    Replies:
    4
    Views:
    1,398
    Alexey Smirnov
    Apr 26, 2007
Loading...

Share This Page