[soesanmg]

Yes. I want to give my php file for looking up what is wrong. Pleas drown load in the following links
SEND6 - Send large files In this link is sql file too.
Please help me. what is wrong. If i write php code wrong, Please explain me. If you have a same code for my php code, Please give me as example . very very thanks...

[wirehopper]

Please post the currency exchange code in the forum. It makes it easier for people to help you.

[soesanmg]

ruble.php
<?
include("includes/db.php");
$result=mysql_query("select * from products");
$R=$_GET['rub'];
while($row=mysql_fetch_array($result))
{
$id=$row['productid'];
$a=$row['currencies'];
$type=$row['type'];
if($R!=$type&&$type=='US dollor'){
$b=($a*30);
}
else if($R!=$type&&$type=='Ks'){
$b=($a/50);
}
else {
$b=$a;
}
$sql =mysql_query("update products set currencies ='$b',type='Ru' where productid='$id'");
}
header("location:index.php");
exit();
?>

[soesanmg]

dollor.php

PHP Code:

<?

include("includes/db.php");

$result=mysql_query("select * from products");

$D=$_GET['d'];

$z=$_GET['do'];

while($row=mysql_fetch_array($result))

{

$id=$row['productid'];

$p=$row['price'];

$a=$row['currencies'];

$type=$row['type'];

if($D!=$type&&$type=='Ks'){

$a=$row['currencies'];

$b=($a/1000);

} 

else if($D!=$type&&$type=='Ru'){

$a=$row['currencies'];

$b=($a/30);

}

else{ 

$b=$p;

}

$sql =mysql_query("update products set currencies='$b',type='US dollor' where productid='$id'");

}

header("location:index.php");

exit();

?>

[wirehopper]

I think you should look at some of the scripts in HotScripts. Your code doesn't look like it can adapt to changes in the exchange rates without code changes.

The price for items should be stored in the database in the currency of the store - if it is a Russian store, it should be Russian currency. Then, if a person wants to pay with a different currency, the Russian price should be converted to the requested currency, based on the current exchange rates.