Page is a not externally linkable
- Code, Content, and Presentation
-- Databases
---- design question: store products priced in different currencies


topr8 - 9:29 am on Mar 3, 2011 (gmt 0)


>>stored procedures

these are queries or series that are saved in the database, it is just a different way of querying the database - personally i use them almost exclusively for everything, but that's a whole other question.

>>multi currency

if i understand you, you are looking to display a product in its original currency and then for reference show it in the user's currency as well?

otherwise your plan on how to do it seems reasonable to me, the MSRp and the currency in the product table and a table with currency conversion rates.
i'd then do the calculation in php or what ever your server language is.

is the site informational? or are you actually selling the products?


Thread source:: http://www.webmasterworld.com/databases_sql_mysql/4274305.htm
Brought to you by WebmasterWorld: http://www.webmasterworld.com