Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Need Report by product


kty242

Recommended Posts

Hello all,

 

I've looked in contributions and pretty much everywhere, but haven't found what I need yet.

 

My site sells movie tickets, and clients pick up their tickets at the will call window the day of the show.

 

I need to create, for each prioduct/movie, the list of customers who bought it, and how many they bought.

 

I'm not familiar with sql or php, I don't think I can create a program from scratch... but if someone had something similar maybe I'd be able to modify it for my purpose.

 

Any help would be cool, send me your own apps if they're close to what I'm looking for, or even links to places where I could learn the basics real quick and maybe try to make that app from scratch...

 

or just tell me if you think there's no way a novice to php and sql (but computer literate) can figure it oput in less than a week...

 

thanks in advance

 

Cat

Link to comment
Share on other sites

I find the easiest way to do things like this is with Access, which makes writing queries very easy. Plus it has the benefit of generating the sql code as well.

 

I just created a query to list the customers name, the product name and quantity purchased in about 10 seconds.

 

Thanks,

Jon.

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...