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 


[Boofo]

I have something like that here:

PHP Code:

$attachs['MBbytes'] = number_format($attachs['MBbytes'], 2); 


But it won't round the last decimal up if the one before it is 5 or more, will it? It just chops it off there, right?

[filburt1]

It won't round at all, probably.

[Boofo]

Is there any way to make it round up or is what I got the best I can get?

[Gary King]

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

[Boofo]

Today at 06:01 PM Gary W said this in Post #14
http://www.php.net/round

I tried that already. Thanks, anyway.

[Gary King]

And it doesn't work?

[Boofo]

No, it rounds 2.12 MB to 2 MB and if I use number_format(attachsmb), 2), then it rounds it to 2.00. It must be the way I am trying to cache it.

[filburt1]

round will still work. Look at the second argument.

[Boofo]

05-28-03 at 08:07 PM filburt1 said this in Post #18
round will still work. Look at the second argument.

You totally lost me now. What 2nd argument?

[gmarik]

PHP Code:

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