[RESOLVED] Number format while building SQL

[Steve1040]

Hi
I have the following code which builds my sql statement
$sql = "REPLACE INTO $table ($field1,$field2,$field3,$field4) VALUES ('$values[0]','$values[1]','$values[2]','".($values[2] * $field4m)."');";

btw: field4m is assigned a static decimal number like .1523

the field 4 calculation returns something like 10.213453
How can I only return 10.21?

Thanks
Steve

[m_tt]

Unless you absolutely need to see the full decimal value, you should always set your MySQL float values to the decimal places you expect in the end result. For example: FLOAT(8,2)

Otherwise, you could use PHP's number_format() or a method that I've never tried:

SELECT FORMAT( SUM( `field4` ), 2 ) AS `number_format` FROM `MyTable`

See MySQL String Functions:
http://dev.mysql.com/doc/refman/5.0/en/string-functions.html

[NogDog]

Assuming it's MySQL, you could use its ROUND() function.

[Steve1040]

thx - Used Round before I created sql string but after line is read.