Not sure I understand... The rate in this case is 0.85 in the db table. I'm looking at the columns in Navicat THEY ARE DECIMAL FIELDS... I pasted this in the page: <h1> HERE<?php echo $GoldPrices->getColumnVal('price'); echo $GoldPrices->getColumnVal('rate') ; ?> </h1>
but the price and the rate do not post.
This is the call from the connection:
<?php
$GoldPrices = new WA_MySQLi_RS("GoldPrices",$LiveGold_i,1);
$GoldPrices->setQuery("SELECT * FROM goldprices WHERE metal = 'metal'");
$GoldPrices->execute();
?>