The value of the array all are null
echo $currency;
echo $currency_symbol;
echo $exchange_rate;
display nothing
But, the sql is not problem.
How should get the array properly?
getCurrency();
echo $currency;
echo $currency_symbol;
echo $exchange_rate;
function getCurrency()
{
$query = "SELECT * FROM currency WHERE id = '1'";
$result = mysql_query($query);
if ($result) {
while ($row = mysql_fetch_assoc($result)) {
$currency = $row["cur_id"];
$currency_symbol = $row["cur_symbol"];
$exchange_rate = $row["ex_rate"];
return array($currency, $currency_symbol, $exchange_rate);
}
}
else
{
return array(null, null, null);
}
}