Summary of Items Ordered

[Guest]

I think that I have searched every post and I can't seem to find anyone having the same problem I am.

 

I have implemented a registration site that allows people to register for an event and at the same time order t-shirts and other related items. What I need, however, is a spreadsheet that will look like the following:

 

 

Order ID____# of Tickets___# of L T-Shirts____# of XL T-Shirts

 

1 ____________5_____________3_______________2

2____________10____________5_______________5

3____________30____________0_______________0

4____________15____________5_______________10

 

 

Does anyone have any ideas how I can make this happen? I am messing with ODBC and Crystal Reports, but I am not too farmiliar with it. Do I need to make another table and have the order-process.php page insert the records?

 

Any help would be appreciated.

 

www.idmediagroup.net/ibsa/registration/default.php?cPath=21

[BrendanB]

Hi Jim,

 

Did you get anywhere with this?.

 

Do you want to just run crystal against the mysql tables to get order details?.

if so.

 

I would consider making a group by OrderID, linked to the order details table, as the details lines

 

 

Does this help?.

 

Crystal isnt that hard to use once you get your head around what tables you want to link up.

 

hth

brendan