|
MaD2ko0l
Senior Member
United Kingdom
1053 Posts |
 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. |
© 1999-2010 MaD2ko0l |
|
Checking data from 2 tables?
