[SOLVED] help with code

[steviez]

Hi,

 

I run a upload site and need some help with the coding..

 

What i am trying to do is show how much disk space a user has used, all the users details and uploads are stored in a database and all upload go in to one file called "files"

 

Is this possable using php?

 

Thanks

[obsidian]

Are you storing the individual file attributes (filesize, name, path, etc) in the database? That would be the wisest and easiest way to go. With that, you could simply query your database for the SUM() of all their filesizes, and you would be able to know exactly what had been used and is available.

[steviez]

Yes i am, i am new to php.. could you help me with this

[obsidian]

If you have the filesize stored in the table along with who it belongs to, you can run a SUM() query to get the total filesize of all their files. Somthing like this may be what you're after:

<?php
$sql = mysql_query("SELECT SUM(filesize) AS total, userID FROM myFileTable GROUP BY userID");
?>

 

That query will give you the total filesize of all users tied to their userID. Of course, you'll have to provide your own table names and column names, but the principle is there.

[steviez]

Hi,

 

Thanks for that it workd great, this might be a silly question but. how do i echo the result?

[razta]

$result = mysql_query ($sql); 
echo $result;

 

That should work.

[steviez]

nope it dont work, my sit euses adodb for the sql

[steviez]

sorted it out, thanks for all your help guys!