Snitz Forums 2000
Snitz Forums 2000
Home | Profile | Register | Active Topics | Members | Search | FAQ
 All Forums
 Community Forums
 Code Support: ASP (Non-Forum Related)
 Checking data from 2 tables?

Note: You must be registered in order to post a reply.
To register, click here. Registration is FREE!
Before posting, make sure you have read this topic!

Screensize:
UserName:
Password:
Format Mode:
Format: BoldItalicizedUnderlineStrikethrough Align LeftCenteredAlign Right Horizontal Rule Insert HyperlinkInsert EmailInsert Image Insert CodeInsert QuoteInsert List
   
Message:

* HTML is OFF
* Forum Code is ON
Smilies
Smile [:)] Big Smile [:D] Cool [8D] Blush [:I]
Tongue [:P] Evil [):] Wink [;)] Clown [:o)]
Black Eye [B)] Eight Ball [8] Frown [:(] Shy [8)]
Shocked [:0] Angry [:(!] Dead [xx(] Sleepy [|)]
Kisses [:X] Approve [^] Disapprove [V] Question [?]

 
   

T O P I C    R E V I E W
MaD2ko0l Posted - 30 September 2011 : 11:42:14
Hi,

not to sure how to put this but here we go.

I have somthing like a file manager.

and i need to have a report of who has downloaded each file.

Now what i need to do is list each file that has been uploaded down the left and then list the date/time in which each user has viewed the file.

so each line woudl look liek this:

<filename> | <user1 date/time> | <user2 date/time> | <user3 date/time> | <user4 date/time> etc etc etc

but i am having trouble getting the data to populate.

i have 3 tables

tblUsers
tblFiles
Clicks

Clicks holds the userID, fileID and DateClicked of who ever has clicked

Not sure if this is clear or if anyone can point me in the right direction.

Any help is much appreciated.
1   L A T E S T    R E P L I E S    (Newest First)
Carefree Posted - 30 September 2011 : 17:15:50
You should include at least one field (eg fileid) that is common to your clicks & your tblfiles. With that you can update/retrieve the proper record.

Snitz Forums 2000 © 2000-2021 Snitz™ Communications Go To Top Of Page
This page was generated in 0.02 seconds. Powered By: Snitz Forums 2000 Version 3.4.07