kty242 Posted January 27, 2004 Share Posted January 27, 2004 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 More sharing options...
jon_l Posted January 28, 2004 Share Posted January 28, 2004 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 More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.