What I need to do, is to make a simple little report that shows the overall file sizes by user.
Users are able to upload images to my server, and also are able to resize, crop, the images as well. So the file size can change many of times.
The FileNames are stored in the database, as well as the user.
So what I'd like is a on-demand script that will Look at the DB for the File Name, compare it to the directory where the files are stored, and maybe even write back the total amount of used disk space by user to the DB.
So that being said, here's my table:
Filetable:
Id--Filename--IP Address--Date--Status--Pkey--User
How do I go about this??