Need to manage currecy value for country vice

Dear friend,

we are developing product. We need to manage currency value for all countries in

my database. This is my requirement. For eg.,

country name currency value currency code

US 45 $
UK 82 pounds

Like the above table. If i enter all countries currency value is critical. Is any schema available or any dynamic table, options available in database >????

Hope yours reply

I don't understand your issue. Please try and explain again. Thanks. :)

Dear friend,

Thanks for your reply.

What i am asking that shall i maintain currency value in the data base for all

countries? All the countries values are maintained in the single table. This is

needed to me.

So make a table with:
Currency|Value

But what are you going to use to determine the value? Compare every currency vs the US $? Or store a conversion rate?

These values are not constant..