Addition, Division etc... in PHP

Discussion in 'PHP' started by you-cubez, Jun 15, 2007.

  1. #1
    Hey -

    I have a number stored in MySQL as an integer. How do I output:

    Number Stored in MySQL / 50 ?

    I need the output to be rounded up as a whole number. Eg 67 NOT 67.77

    Thanks in advance
     
    you-cubez, Jun 15, 2007 IP
  2. krakjoe

    krakjoe Well-Known Member

    Messages:
    1,795
    Likes Received:
    141
    Best Answers:
    0
    Trophy Points:
    135
    #2
    you have floor and ceil to round down and up respectively, and maths functions work as you would expect them to

    
    $num = 500;
    echo $num / 20.2323 ;
    echo "<br />";
    echo floor( $num / 20.2323 );
    echo "<br />";
    echo ceil( $num / 20.2323 );
    
    PHP:
    like that
     
    krakjoe, Jun 15, 2007 IP
  3. YIAM

    YIAM Notable Member

    Messages:
    2,480
    Likes Received:
    240
    Best Answers:
    0
    Trophy Points:
    280
    #3
    floor() should work.
    
    floor($value/50);
    PHP:
     
    YIAM, Jun 15, 2007 IP
  4. you-cubez

    you-cubez Active Member

    Messages:
    842
    Likes Received:
    24
    Best Answers:
    0
    Trophy Points:
    60
    #4
    krakjoe - Ok... so say I currently output the number like:

    $query="SELECT * FROM Cubez ";
    $sql=mysql_query($query);
      {
         while ($cubedata=mysql_fetch_object($sql)) 
            {
    	$msg.="  				
    		".$cubedata->Number1. "	
    	";
    PHP:
    Can I simply do: ".$cubedata->Number1 " / 50??
     
    you-cubez, Jun 15, 2007 IP
  5. krakjoe

    krakjoe Well-Known Member

    Messages:
    1,795
    Likes Received:
    141
    Best Answers:
    0
    Trophy Points:
    135
    #5
    ". $cubedata->Number1 / 50 . "

    you can do that .....
     
    krakjoe, Jun 15, 2007 IP
    YIAM likes this.
  6. you-cubez

    you-cubez Active Member

    Messages:
    842
    Likes Received:
    24
    Best Answers:
    0
    Trophy Points:
    60
    #6
    ". $cubedata->Number1 / 50 . " - That works, but outputs the integer with a decimal point. How do I round it DOWN to a whole number. So if the answer is 56.78 it outputs 56???

    Thanks a lot!!! :)
     
    you-cubez, Jun 15, 2007 IP
  7. krakjoe

    krakjoe Well-Known Member

    Messages:
    1,795
    Likes Received:
    141
    Best Answers:
    0
    Trophy Points:
    135
    #7
    ". floor( $cubedata->Number1 / 50 ) . "
     
    krakjoe, Jun 15, 2007 IP
  8. you-cubez

    you-cubez Active Member

    Messages:
    842
    Likes Received:
    24
    Best Answers:
    0
    Trophy Points:
    60
    #8
    krakjoe - Thank you ever so much! Also... if you're interested, I have a few other small pieces of coding I could use some help with. I'm willing to pay!

    The site is www.you-cubez.com

    PM me if interested. Thanks
     
    you-cubez, Jun 15, 2007 IP