A current project requires a list of world currencies. I got the ISO-4217 codes from the link: http://fx.sauder.ubc.ca/currency_table.html and extracted the country name, currency name and symbol into a mysql table.
Attached is the mysql statements (the create table and inserts) in case it is needed by someone else - so u dont av to go through the stress of the extraction like I did.

For those interested in the extraction details, here is how I went about it. I simply checked the source code, copied out the table element containing the currencies (name, currency, symbol, code) and saved it in a file (currencies.txt).
I then used the following snippet to match, extract and insert into the mysql table.

<?php
mysql_connect("localhost", "root", "";
mysql_select_db("tests";
//
$content = file_get_contents('currency.txt');
preg_match_all("/<tr.*>(.*)<\/tr>/Usi", $content, $all);
$matches = $all[1];
foreach($matches as $match)
{
list($country, $currency, $iso, $symbol) = split('</td>', $match);
$country = trim(strip_tags($country));
$currency = trim(strip_tags($currency));
$iso = trim(strip_tags($iso));
$symbol = trim(strip_tags($symbol));
if(!empty($currency) && !empty($iso))
{
mysql_query("insert into `bills`.`currencies` (country, currency, symbol) values ('".addslashes($country)."', '".addslashes($currency)."', '$iso')";
}
}
?>

It is a very rough piece of code - was so much in a hurry to do it better. Feel free to tweak in watever way. Whatever, this one altleast works.

Lovely addition to the forum. These are the types of posts I look forward to seeing in 2009, as opposed to "chest thumping, do you know who i am?" posts.

Thanks brother.

@yawa,

Thanks for hitting a mil on your posts


@kehers

Nice job bro. Keep it up!

Merry Xmas and Happy New Year in Advance!

Thanks bro, it's people like you that God will bless in 2009.
U TOO MUCH JOO