monkeytooth Posted April 11, 2010 Share Posted April 11, 2010 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? Quote Link to comment Share on other sites More sharing options...
litebearer Posted April 11, 2010 Share Posted April 11, 2010 Decimal should do fine; might consider a field that defines the currency ie dollar us, euros etc Quote Link to comment Share on other sites More sharing options...
monkeytooth Posted April 11, 2010 Author Share Posted April 11, 2010 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. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.