Money Values in MySQL
I am trying to insert values into a column that will be dollar values. They are each the price of a product in its corresponding row. The goal of this database is for it to be sortable by price. I have been able to do this, but I cannot store commas in the database with the numbers without losing the order-by-price ability. How do I store commas with integers while still being able to sort by this column?
Example:
I want to be able to input the following: 400; 1,920; 32; 147,010 and be able to order everything.
BTW, I am using PHP to interface with the database.
Thanks,
Jeremy
Subject
Written By
Posted
Money Values in MySQL
September 08, 2004 11:13PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.