What type of number field in a MySQL table accepts commas...

[garethashton]

I have a MySQL table set up on my server. I have a php script that sends data to the table.
One of the fields is for holding money values (11,000).
Right now it is set up with INT as the type.
If I type 11000, then it reads the number correctly, but if I type 11,000, then it reads the number as 11!

I know how to overcome this in Access, but does anyone know the TYPE I must use to accept a number (so it can be used in calculations), but also contain a , (comma) in MySQL??

 

[tlbroadbent]

Check the MySQL documentation. If you don't have any, it can be found online at

http://www.mysql.com/documentation/index.html.

As this is an MS Access forum you may not get an answer here. Terry

http://members.home.net/tlbroadbent/prog.htm

The reason why worry kills more people than work is that more people worry than work. - Robert Frost