probably really easy .. but...

[Anon]

I am having trouble, i am pulling information out of a database, its supposed to be price, but has waaay more than 3 #'s after the decimal point, is there a quick and simple way of limiting the variable i am inserting it into, in my PHP code, to using just 2 decimal places?

Thanks

[swampy]

IF you are using mysql. define the field as FLOAT (4,2) 4 gives you 4 significant figures and 2 gives you a maximum of 2 decimal places. Or you could use the DECIMAL field type. Not sure how that works though