MySQL Forums
Forum List  »  Newbie

Money Values in MySQL
Posted by: Jeremy White
Date: September 08, 2004 11:13PM

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

Options: ReplyQuote


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.