[RESOLVED] mysql decimal problem

[ldtiw]

Hi,

Im trying to enter a value into my database but for some reason when the value is above 1000 it enters 0.00.

This is the code:

mysql_select_db($database_rince, $rince);
$result1 = mysql_query ("SELECT rate FROM rw_exchange_rates WHERE currency = '".$_POST['i_currency']."'"); 
$myrow1 = mysql_fetch_array ($result1);
$result2 = mysql_query ("SELECT rate FROM rw_exchange_rates WHERE currency = 'GBP'"); 
$myrow2 = mysql_fetch_array ($result2);

$from = $myrow1['rate'];
$to = $myrow2['rate'];

$price = $_POST['i_price'];
$GBP = number_format(($price/$from)*$to,2);
$pkval = $tNG->getColumnValue('i_id');

mysql_select_db($database_rince, $rince);
$update_price = "UPDATE rw_dress_listing SET i_price_gbp = ".$GBP." WHERE i_id = ".$pkval;
$update_price = mysql_query($update_price);

i_price_gbp is decimal (10,2)

there are another 2 decimal rows that have (10,2) and they are fine. Just that one for some reason. Any ideas?

Thanks allot!

Danny

[ldtiw]

hi there,

After doing a search on here to find out about decimals i fixed the problem.

$price = number_format($_POST['Price'], 2, '.' ,''); (from another post)

Im guessing that because i didnt have the thousand seperator set to '' it wasnt allowed to enter 1,000.00. Using '' would enter 1000.00!!

This site is really hand for finding stuff, sorry i didnt try looking sooner!

Thanks
Danny