changing format of data

[joebudden]

Hi guys, I've written code to display the total size of files in a database...

[code]
$query2 = "select sum(size) as total from artefact where dbEmployeeId='".$_SESSION['sessEmployee']['id']."'";

$allowance = mysql_query($query2);
$a = mysql_fetch_array($allowance, MYSQL_ASSOC);
echo '<p>You have used <b>';
$total = $a['total']/ 1024;
echo round($total);
echo ' KB</b> of your total file size allowance</p>';
[/code]

This works fine...

However I was wondering if there was any way of displaying the size as MEGA BYTES once the total reaches a MEGA BYTE???

I.E IF the total is 200kb it displays 200kb....
   
...but IF the total is 1200kb it displays 1.2mb

Would this be simple to achieve or too complicated ?

Any help appreciated

cheers guys

[PC Nerd]

no its easy..... i think

all you would bave to do, is once you have the kb count of the file length, you do something like this


[code]
$total2 = total / 1024;

if($total2 > 1) {
echo $total2;
echo "KB</b> of your total file size allowance</p>";}
[/code]

you could use another else if () { } for GB if you really needed


good luck

[joebudden]

No that didnt work anyone else ???

[PC Nerd]

is the $total variable text or an integar.  if its text, make it an integar and that will allow you to do math orrerations on it, if its text, thats why it didnt work, becauase your deviding text by a number which obviously wont work

[joebudden]

Cheers PC Nerd GOT IT WORKING ;D

heres the code I used

[code]
<?php
//query to select total size of files in database
$query2 = "select sum(size) as total from artefact where dbEmployeeId='".$_SESSION['sessEmployee']['id']."'";

$allowance = mysql_query($query2);
$a = mysql_fetch_array($allowance, MYSQL_ASSOC);
$total = $a['total']/ 1024;
$totalMB = $total / 1024;

//display total size in MegaBytes
if($totalMB > 1)
{
echo '<p>You have used <b>';
echo round($totalMB,2);
echo "MB</b> of your total file size allowance</p>";
}
//display total size in KilaBytes
else
{
echo '<p>You have used <b>';
$total = $a['total']/ 1024;
echo round($total);
echo ' KB</b> of your total file size allowance</p>';
}
?>
[/code]

[marcus]

[code=php:0]
<?php

if(is_numeric($total) && str_len($total) == 4){
$nt = round($total);
$dv = $nt/1024;
echo "You have used $dv MB";
}else if(is_numeric($total) && str_len($total) < 3){
$nt = round($total);
echo "You have used $nt KB";
}
?>
[/code]

[marcus]

[code=php:0]
$a = mysql_fetch_array($allowance, MYSQL_ASSOC);
$total = $a['total']/ 1024;
$totalMB = $total / 1024;
[/code]

If $a['total'] equaled 1024 then $total would equal 1 and then $totalMB would equal 1/1024 which is 0.0009765625.

[PC Nerd]

glad i could help