Basically...you can't. What I meant was that when you insert the data into the table, you need to store the size as well.
Consider the following table (called files):
dataID user filename size filedata
[int, autoincremented] [int] [varchar] [int] [blob]
Now, let's say user 3 uploads the file 'airplane.jpg' to the server. We need to have the following information:
$filename = The name of the file
$filedata = The actual file
$size = The size of the uploaded file
You can find out about how to get these variables from http://www.php.net/manual/en/features.file-upload.php
Then you insert the data into your table;
"INSERT INTO files(user, filename, size, filedata)
VALUES (3, $filename, $size, $filedata)"
This means that every time some user upload a file, the size of the file will be tied to a particular record. Then you just use MySQLs built-in SUM function to find out the total amount of data (check my previous post)
Kindly
/Lars Olsson ([EMAIL PROTECTED])
Denis L. Menezes wrote:
Thanks Lars. Sorry, then I have another question. How do I find the size of the record?Thanks Denis
-- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
