Reputation: 37

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

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.

Upvotes: 2

Answers (4)

Reputation: 2362

use this in php

money_format(string,number);

Upvotes: 1

Reputation: 941

You also use PHP function -

number_format($num)

Upvotes: 1

Reputation: 327

you can use function : number_format($number)

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

Upvotes: 2

Reputation: 11693

use format function

SELECT FORMAT(235693,0);

Upvotes: 1