I am trying to calculate in php. But my problem is, i want a figure like this ( $25,000.20) in MYSQL database, but none of my column types are accepting it.
I tried Float, Double, Decimal, but none is working. They only allow my script to calculate the numbers before the (,) comma sign. Is there something am not doing right???
This is what am calculating;
Code: Select all
<?php
if($amount - $amount_to_send < 100) {
$msg='Error, The amount you specified is higher than your transfer limit';
}
?>