prices and currencies ASAP

[buducom]

ASAP
I need to know which field
to use in MYSQL and what parameters the field
should have for saving currencies.

Also some PHP functions to handle them.
What i need is save one type of currency like DOLLAR

1500.34

and when reading be able to convert it in different formats.
But i dont know which field type and what parameters
for the field so i can store these values.
and how do i check whether the user put it correctly in
when submitting it via form.

Thank you!

Daniel

[TheIceman5]

i cant remember, think decimal(10,2) or something, search google.

[Sadmin]

I need a code to obtain the nation al currecy exchanges (COP colombian Peso) from dollars, this value must update dynamically at leas daily...
yahoo.com ism y favorite site to consult these data, in this page sits said that data is collected from Reuters, in hotscripts.com i ound some scripts that make it (currency exchange / consultation) the bad thing is that they are toocomplex and to fin the exact funciton that i Nedd within them is very difficult, it's earier to begin it from zero, someone has experience? someonhe has an idea?
I understand that most ofp ages (if not all) htat have this financial info obtain it from another reliable site of the internet

[examancer]

not sure exactly what you're looking for, but if you find a site with reliable currency exchange info it shouldn't be too hard to use some string functions to automatically strip the rates from the page daily... just look at the HTML structure and look for some peices of code surrounding the numbers you want that you can use in a script to seach for those numbers. I make scripts like these all the time... from striping lyrics from a lyrics site, to striping pictures from a... well... other type of site.

[LordShryku]

http://www.php.net/money_format