I'm trying to code a small site with a search function on it. One of the values that is can be search is the price of a product. Till now I was stroring the price as a varchar() type, but this way it can not be used to do a search query with "BETWEEN". (example: BETWEEN 20 and 50) Anyone here who can tell me what I should use as type in the MySQL? Please note that the Dutch format of currency use is like this: 1.000,50 (one thousand euro and 50 cents) and: 25,75 (twenty five euro and seventy five cents) Or.. Is there an other way of doing this? Once again thank you for any info on this.
I'd probably use DECIMAL. See http://dev.mysql.com/doc/refman/5.0/en/numeric-types.html You can use the number_format() PHP function to convert the values into the right format.
