What I normally do is: if the number is a percentage you can print it directly or make the calculation with PHP... or (read below) create a function). Depending the case I don't know about any MySQL function to do this..
[php]
...
function perc($num) {
return format_number($num,2)." %";
}
$data=mysql_fetch_object($sql)) {
print $data->perc . " %"; # Example A
print (($data->percn*$data->total)/100); # Example B
print perc($data->perc); # Example C - using a function and some extra format -
}
[/php]
Reputation Points: 10
Solved Threads: 2
Junior Poster in Training
Offline 57 posts
since Mar 2005
Unsolved 
