close ad
WARNING: Do Not Install the DREAMWEAVER CC 2017 or 2018 Update »
open ad
View Menu

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

rating

Selling Ticket packages. Need multiple options.

Thread began 2/08/2010 1:51 pm by nenad391153 | Last modified 2/09/2010 10:34 pm by nenad391153 | 723 views | 6 replies |

nenad391153

Selling Ticket packages. Need multiple options.

Hello,

Our client is selling tickets to events. Each event has multiple packages (e.x. General admission, VIP, VIP Cabana, etc.) Each ticket package has it's own price. So basically one event will have different package options with different prices. Each event will NOT share the same packages and/or prices.

We have successfully created all of the data-assist admin pages to insert a single event with a single price into the products table. We are now having trouble trying to figure out how to add multiple ticket packages with each it's own price to one event.

What would be the easiest way create multiple ticket packages and prices for one single event? Is there a way to simple add to our products_insert.php file the necessary form elements to insert these records?

Thank you for your time,
Nenad

Sign in to reply to this post

nenad391153

Any help greatly appreciated.

I was hoping anyone could help. We are pressed on time and any help would be greatly appreciated.

Thanks!

Sign in to reply to this post

Office Guy-172461

I think I would do something like this:

Assign an event code for each event

Create a table with:

EventCode
package
package_price

The master table has all of the information for the event and you would look up the available packages and prices from the secondary table.

You can use the order and orderdetail tables in the eCommerce database as a guide as a guide.
ecommerce-database/

Sign in to reply to this post

nenad391153

Don't quite understand...

Thank you for the prompt reply Office Guy-172461, however I do not believe I am fully following your post. Could you possibly elaborate a bit?

Thank you!

Sign in to reply to this post

Office Guy-172461

Hopefully I'm following what you want :)

Think of the price packages as options for the event (product).

Instead of :

Concert featuring all of your favorite groups $50

It would be:

Concert featuring all of your favorite groups (product - unique event code)

and then you lookup and display all of the packages available for that event code from the second database (options)

Which would look like this:

Concert featuring all of your favorite groups
General admission $50
VIP $150
VIP Cabana $500

All of these option share the same event code so they would only show up on the product page with the same event code.

Sign in to reply to this post

Office Guy-172461

Maybe this will help:

Designing a Database
161/

In the example, Customer Orders Products table would be the event options
order_id would be package_id
quantity would be packge_price
comments would be package_name

The Product table would be your Event table and contains all of the info about the event except prices.
product_id would link the two tables.

Sign in to reply to this post

nenad391153

Thanks

Thanks Office Guy. Unfortunately I wasn't able to figure it out.

We have resorted to an alternate, "not what I intended" solution.

Thanks anyway!

Sign in to reply to this post

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now.  Build a store, a gallery, or a web-based email solution.

Want your website pre-built and hosted?

Close Windowclose

Rate your experience or provide feedback on this page

Account or customer service questions?
Please user our contact form.

Need technical support?
Please visit support to ask a question

Content

rating

Layout

rating

Ease of use

rating

security code refresh image

We do not respond to comments submitted from this page directly, but we do read and analyze any feedback and will use it to help make your experience better in the future.

Close Windowclose

We were unable to retrieve the attached file

Close Windowclose

Attach and remove files

add attachmentAdd attachment
Close Windowclose

Enter the URL you would like to link to in your post

Close Windowclose

This is how you use right click RTF editing

Enable right click RTF editing option allows you to add html markup into your tutorial such as images, bulleted lists, files and more...

-- click to close --

Uploading file...