Member Avatar for Stick

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

  • 2 Contributors
  • 1 Reply
  • 435 Views
  • 7 Hours Discussion Span
  • Latest Post Latest Post by RamiroS
Member Avatar for RamiroS

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 -
   
}
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.