storing dollar amounts

[monkeytooth]

I am trying to figure out what the best way to store a dollar amount is. But I should be more specific. Right now I am starting off with dollars, but eventually am going to store other currency types to. But I want to be able through my queries with php sort my listings highest to lowest, within a range of a to b.. so I'm not sure what the best way to store the dollar amounts is. Would I use decimal, float, text, something else? What would you guys suggest?

[litebearer]

Decimal should do fine; might consider a field that defines the currency ie dollar us, euros etc

[monkeytooth]

well I do have a column in my table that in a sense specifies which is which, I have an INT column storing numeric pairs, the pairs are hard coded in but essentially determine for me at least which currency type is being used. I don't know if thats what you meant or not. But thought it worth mentioning to find out :-)

 

Thanks for the advice prior.