Attachment Count in MB

Can anyone please tell me how to pull the MB out of an attachment query? Here is the code for pulling out the KB but I can't seem to find the right code for the MB. I know it is simple, but I must not be very good in the math department.

PHP Code:

SUM(LENGTH(attachment.filedata))/1024 AS KBbytes 

[assassingod]

PHP Code:

SUM(LENGTH(attachment.filedata))/1048576 AS KBbytes 

?

[Boofo]

I had that but I want to get it like 2.12 MB. instead of just 2 MB. How do I get it to go the 2 decimal places?

[filburt1]

<a href="http://www.php.net/round" target="_blank">http://www.php.net/round</a>

[Boofo]

I tried that, too. When I round 2,174,891, I get 2 MB. This is how I used round:

PHP Code:

$attachs['MBbytes'] = round($attachs['MBbytes']); 

[filburt1]

Then:
[sql]
...SUM(LENGTH(attachment.filedata)) / 1024 * 1024 * 1024 AS mbytesum...
[/sql]
...then round it.

[Boofo]

That threw it way off. Here's the code I am working with if that will help.

PHP Code:

/** Count of Attachments Per Forum and Bytes **/
$attachs=$DB_site->query_first("SELECT forum.title AS forum, COUNT(attachment.attachmentid) AS count, SUM(LENGTH(attachment.filedata)) AS bytes, SUM(LENGTH(attachment.filedata))/1024 AS KBbytes, SUM(LENGTH(attachment.filedata))/1048576 AS MBbytes
FROM attachment,post,thread,forum
WHERE attachment.attachmentid = post.attachmentid
AND post.threadid=thread.threadid
AND forum.forumid=thread.forumid
AND forum.forumid=$forumid
GROUP BY thread.forumid
ORDER BY count DESC");

$attachs['count'] = number_format($attachs['count']);
$attachs['bytes'] = number_format($attachs['bytes']);
$attachs['KBbytes'] = number_format($attachs['KBbytes']);
$attachs['MBbytes'] = number_format($attachs['MBbytes']);
$attachs['MBbytes'] = round($attachs['MBbytes']);
If ($attachs['MBbytes']<1) {
$attachs['MBbytes']='';
} else {
$attachs['MBbytes']="=" .$attachs['MBbytes']. "MB";
}
If ($attachs['count'] !="0") {
$attachinfo="<tr>
        <td nowrap><smallfont><b>Total Attachments:</b> $attachs[count]</smallfont></td>
        <td nowrap><smallfont><b>Total Attachments Bytes:</b> $attachs[bytes] bytes ($attachs[KBbytes] KB$attachs[MBbytes])</smallfont></td>
</tr>";
} else {
$attachinfo="";
}
/** Count of Attachments Per Forum and Bytes **/ 

[noppid]

Use the php modulus operator to work with the remainder.

http://us3.php.net/manual/en/languag...arithmetic.php

[Boofo]

LOL I just tried that and I was way off. All I am trying to do is go 2 decimal places with the MB and have it rouind up if it needs to.

[filburt1]

Okay, get the sum in bytes, and assume it's in the $bytes variable.

PHP Code:

$megabytes = $bytes / (1024 * 1024);
$megabytes = number_format($megabytes, 2); // add commas and only 2 dec places