1.11M Members

Format Number as percentage.

 
0
 

I have a web page that prints a number from a mysql database.
Can anyone tell me how to show this number as a percent?
Does it need to be formated that way in the database table? or
Can I format it that way using the printf function at the page?
Thanks in advance for any help!
Stick

 
0
 

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..

...
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 -
   
}
You
This article has been dead for over six months: Start a new discussion instead
Post:
Start New Discussion
Tags Related to this Article