Linux Today: Linux News On Internet Time.
Search Linux Today
Linux News Sections:  Developer -  High Performance -  Infrastructure -  IT Management -  Security -  Storage -
Linux Today Navigation
LT Home
Contribute
Contribute
Link to Us
Linux Jobs


More on LinuxToday


Linux Journal: Using MySQL for Exchange Rate Updates

Jun 09, 2004, 08:30 (2 Talkback[s])
(Other stories by James Hatridge)

"I am an American living in Germany, and I export German stamps to English-speaking markets, mainly to the US, UK and Australia. Once a quarter, I mail the new stamps to my customers with a statement priced in their local currency. This means that I have to keep track of the exchange rates for the Euro, US dollar, UK pound and Australian dollar.

"Many years ago, when I started my stamp business, I solved this problem by listening to the radio every day at 6pm, when the daily US dollar fix was issued. I wrote the exchange rate on some scrap paper. It was a mess to keep all these little notes together. The rates for the Australian dollar and the British pound I had to guess when I made my quarterly price list. Today, by using the Internet, MySQL, PHP, KMail, and SuSE 8.2 Linux, all the tracking and conversions are done automatically..."

Complete Story

Related Stories: