[Resolved] total filesize and DB

[goaman]

Hi all!
I'm having fun with mysql db(need help), trying to get total size of many files from mysql which are uploaded by a user. Fields are followings: id, users, files, size. Size of those files are saved in bytes, I can get each of those filesize and display them alright, but I'd like to know how to total all the files from a user and display it as user x totally uploaded X MB.

Thanks!

[devinemke]

SELECT SUM(size) FROM table GROUP BY user

[phil_j_poore]

use the follwing code i think this works....

SELECT SUM(size) FROM table_name;

and if you want to show the total for set users then use

SELECT SUM(size) FROM table_name WHERE users = 'what_ever_user_name';

i'm sorry if this doesnt do what you want it to......

[goaman]

Thankyou for the fast reply guys 😃, I've used this, working great 🙂

$query = mysql_query("SELECT SUM(size) as 'TotalSize' FROM uploads WHERE user='$ThisUser' ");
$row = mysql_fetch_array($query);	
echo $row['TotalSize'];