How to save numbers to mysql database as it is?
01:59 13 Nov 2018

I need to save numbers to database as it is please see the example.

  • currently i save number as 22.5 and in database it is saved as 22.

  • number in database is set as integer

    //sometimes $number can be "33.5" or "33" or "1" or "1.003"or "03"
    $sql = "INSERT INTO active (name, number) VALUES ('somename','$number')";
    
php mysql sql number-formatting