decimal number with comma (,) where required

[fariba123]

requirement 1
--------------------
present data:12000.00(i n database)

required data:12,000.00( display format)

requirement 2
--------------------
there are some decimal data [decimal(10,2)] in database. i have to print the total value in the same format (i.e. 12.00). but i am getting the value as 12.

please help me out

thank you

[ronverdonk]

See FORMAT() function in MySQL doc http://dev.mysql.com/doc/refman/4.1/...functions.html

This is a MYSQL question, so thread moved to MySQL forum.

Ronald :cool:

[fariba123]

thanks for the help. it worked.

See FORMAT() function in MySQL doc http://dev.mysql.com/doc/refman/4.1/...functions.html

This is a MYSQL question, so thread moved to MySQL forum.

Ronald :cool:

[ronverdonk]

You are welcome.

Ronald :cool: