
$divstyle = "style='text-align:center;width:100%;font-size:12px;'";
$cur = array("GBP" => "£", "USD" => "$", "CAD" => "$", "AUD" => "$", "NZD" => "$", "DKK" => "Kr", "SEK" => "Kr", "NOK" => "Kr", "JPY" => "¥");
$conn = mysql_connect("iwml.com","manageiwml","scally") or die("Unable to connect to database");
$currencydb = mysql_select_db("manageiwml") or die("Error: ".mysql_error());
$query = "select * from currency_rates where ";
foreach($cur as $c => $x) $query .= "currency = '$c' or ";
$query = substr($query, 0, strlen($query) - 4);
$result = mysql_query($query);
//while($row = mysql_fetch_array($result)) $$row['currency'] = $row['rate'];
mysql_close($conn);
echo "Current Exchange Rates - Click --> ";
while ($row = mysql_fetch_array($result)){
echo "  ";
if($row['currency'] == "GBP") $gbp = $row['rate'];
}
echo "€1 = $cur[GBP]".number_format($gbp, 2, '.', ',')."";
echo " ";
?>
Latest News Headlines
Tourism, Travel & Leisure News from Ireland
|
|
|
|