Need help on a reg exp. for money

[blaketar]

I’m trying to ensure a user doesn’t accidently add two (or more) decimal points to a price field. For instance 12,000.00 OR 12000.00 is correct. Once in a while however I find 12.000.00 (price contains two decimal points).

Any functions exist for double checking money formats before inserting into a Table:Money:Column?

[darrenG]

[google.com...]

google is your friend!

specifically:

[uk.php.net...]

Hope that helps