What are the potential issues with using INT data type for fields that require decimal values in PHP?

Using the INT data type for fields that require decimal values in PHP can lead to data loss and inaccurate calculations. To solve this issue, you should use the DECIMAL data type instead, which is designed for storing decimal values with precision.

CREATE TABLE example_table (
    decimal_field DECIMAL(10, 2)
);