[SOLVED] Integer doesnt subtract fully

[SirChick]

I have a variable set at 10,800 and im trying to subtract it in my query like here:

$Price = 10,800 in this example.

 

$subtractMoney = "UPDATE userregistration SET MoneyInHand=MoneyInHand-'$Price' WHERE UserID='{$_SESSION['Current_User']}'";
		$result = mysql_query($subtractMoney) or die(mysql_error());
		if (mysql_affected_rows() == 0)
		{
		die('Error ID 0001A, contact admin on the forums immediately about this error!');
		}

 

But the subtraction is only going down by 10. Not 10,800.. although this 10,800 could be any value this was what i used for this example.

[teng84]

10,800<--- is not a number 

try to remove the comma 

[SirChick]

how do you do that :S whats the feature called?

[marcus]

$Price = str_replace(",","",$Price);

[SirChick]

Thanks may I ask how do you do the reverse effect ? Is it:

 

$Price = str_replace("",",",$Price);

?

[marcus]

$Price = number_format($Price); //back to normal

 

echo number_format(10800); //10,800

[kenrbnsn]

use the function number_format()

<?php
$Price = 10000;
$new_price = number_format($price,2);
?>

 

Ken

[SirChick]

Thankyou!

[teng84]

ok i guess your prob is answered and i guess its done if your data types in your db is INT

 

DOUBLE POST!! READ THE LAST POST  ;D