Hi all, long time no post... I've rebuilt a download tracking system my company uses. I built the original, and thought that a restructure would be a doddle! Ooops! ;-)
Anyhoo... I used to capture each download in it's own row, replicating user data each time. (Eg: if a user downloaded 5 files, I'd capture their address, email etc, 5 times) For the redesign, I've got several tables. a file list table, a user list table, and a capture list table. I'm built 90% of the front end, and it works great! However, I'm having trouble getting my head round the reporting side of things. (probably need to stop thinking about it for a while, but I don't have that luxury) My admin users, will come in, and select a file ID to view who's downloaded it. So with a file ID No, I need to also get the following: 1. Get the file info from the file table 2. go to the captures table, get all the fields where the file id is the same as theonce requested 3. count each user that has downloaded it 4. get thier data from the users table Now I could do this with 4 seperate queries, and a few for loops etc... But I'm trying to figure out JOIN... as I'm told I can do it all in one query, and make a temp fake table? I've googled for a decent tutorial, but perhaps I'm just panicing, but they all seem over my head... (My flatmate is a PHP developer too, and she says that it's easy!.. so I hope I'm just stressed) Anyhoo, does anyone know of a decent site, that'll really dumb it down for me, or could talk me through what I'm after? Sorry for the long winded E-mail.. but I'm pulling my hair out here.. :-( Tris... ____ � The WDVL Discussion List from WDVL.COM � ____ To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] or use the web interface http://e-newsletters.internet.com/discussionlists.html/ Send Your Posts To: [email protected] To change subscription settings, add a password or view the web interface: http://intm-dl.sparklist.com/read/?forum=wdvltalk ________________ http://www.wdvl.com _______________________ You are currently subscribed to wdvltalk as: [email protected] To unsubscribe send a blank email to [EMAIL PROTECTED] To unsubscribe via postal mail, please contact us at: Jupitermedia Corp. Attn: Discussion List Management 475 Park Avenue South New York, NY 10016 Please include the email address which you have been contacted with.
