Outputting mysql db fields as formated #s, Using multi-row'd db selections and multi-fields, format the outpu Options

[WotCGM]

Hello All.

I have a db-table in mysql that has 18 fields in it. Of those, 2 are badly formated... ie not at all.
They show up as 1234567890123 .
The data type is bigint.

When I do my select statement in php, I come up with 30 rows of data (proper), but in each
case, the two "badly formated" fields also show up that way.

I would like them to show up as: 1,234,567,890,123 for example.

So, this is both a php and mysql question.

Thanks in advance..

Larry

[Ephraim F. Moya]

Hello All.

I have a db-table in mysql that has 18 fields in it. Of those, 2 are badly formated... ie not at all.
They show up as 1234567890123 .
The data type is bigint.

When I do my select statement in php, I come up with 30 rows of data (proper), but in each
case, the two "badly formated" fields also show up that way.

I would like them to show up as: 1,234,567,890,123 for example.

So, this is both a php and mysql question.

Thanks in advance..

Larry

php has a command called 'number_format' which will format numbers like you want.

http://php.net/manual/en/function.number-format.php

you can't do it in mySQL unless you change the field type from bigint to string.