i use this
Database
i have a 5 col table named TrackDownload that has
DownloadID - Primary Key
DownloadTime - Just to track Time
DownloadIP - Get Users IP Addy
DownloadFile - File Name
DownloadFolder - Folder name
link
http://www.morningz.com/mz/utils/download/getfile.asp?file=/mz/files/public/system_morningztheater.mpeg
ASP code for "getfile.asp" minus my connection object
<%
Dim sFile
sFile = Request.QueryString("file")
'Find the last "/" so we can determin the folder and file name
nDelim = InstrRev( sFile, "/" )
strFile = Mid( sFile, nDelim + 1 )
strFolder = Left( sFile, nDelim - 1 )
strSQL = "INSERT INTO TrackDownload ( DownloadIP, DownloadFile, DownloadFolder, DownloadTime ) VALUES ( '" & _
Request.ServerVariables("REMOTE_ADDR") & "', '" & strFile & "', '" & strFolder & "', '" & _
Now() & "' )"
objConn.Execute strSQL
Response.Redirect sFile
%>
if you need any further clarifications/help, feel free to email me 
Edited by - MorningZ on 23 June 2001 13:03:46
Topic Locked
Posted - 23 June 2001 : 03:08:41
