Currency Symbol change

[SpydrSS]

Hi there.

Thanks for a great forum and to all of you have provided help in the past.

I have a rather small problem. I sell turnkey sites in South Africa, but obviously we don't market them locally, so all the turnkeys are in dollars or Ponds.

So here's my problem, I installed a site for a customer for realty, but the whole site is databased driven, and there's only an option for Dollar and you guessed it Pounds. All i need to do is change the dollar sign to a R...

Seems easy enough, but I have no clue how to use databases, and I've already had to reload his site once.

The site is a realty site from dotcombuilder.. .

here's the link to the site...
http://www.primeproper ty.za.net

cam someone please help me get this customer off my back... PLEASE!!!

Regards
Stanley

[mwasif]

It seems to be a PHP question.

Nobody can tell you exactly what to do. The dollar sign ($) may be written in the .php files or may be coming from the DB.

First you have to search in php files where this text exists.

[SpydrSS]

Hi there.

Thanx for the info, it's not in the php, it's in the database, please help me, What do i look for and what do i change?

Regards
Stanley

[mwasif]

Then there must be a table, named similar to 'currency range' or 'prices'. First you have to identify the table, the column names and data type.

To browse the mysql tables, you should have phpMyAdmin (a web application to perform mysql operations) in your hosting crontrol panel.

After finding the exact table and column, you can issue a REPLACE command to replace $ with your requried symbol.

[SpydrSS]

hi there.

thanks for the help...
please find attached pic. I did the change but nothing happens...

I'm not sure i did it correctly, i did a search for pound and it came up with all the pounds and i edited currency...


Any help here would be apreciated.

[SpydrSS]

Here's the only thing I found with Pound... All I need to do is change the £ to R...

[mwasif]

In which table you replace the symbol?