如何在从数据库中选择值时以格式显示数字(1234->为1,234)

How to display numbers with format(1234->as 1,234) while selecting values from database

SELECT rates,invoice FROM data;

Now Rates are displaying as 235693 like this,but i want display it as 2,35,693.

use format function

SELECT FORMAT(235693,0);

use this in php

money_format(string,number);

you can use function : number_format($number)

<?php
   $number = 10000;
   $formatted_number = number_format($number);
?>

You also use PHP function -

number_format($num)

Also look on link - http://php.net/manual/en/function.number-format.php