Non-numeric value error?

Hi Ray, I have created the new connection to the db for mysqli and php 7 for the site I'm redoing.
I am now encountering this error:

$
Warning : A non-numeric value encountered in /usr/home/buyer.com/pages/gold3.php on line 265


this is the line:
$<?php echo number_format (($GoldPrices->getColumnVal('price') * $GoldPrices->getColumnVal('rate') * 0.0208), 2) ; ?>

Does this indicate that the column for price is in the wrong format? This is the value in that column: 1910.00

It implies that either price or rate are not a number. Write both of them separately to the page to make sure they have the values that you expected.

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();
?>

Most likely your recordset isn't returning a value.

SELECT * FROM goldprices WHERE metal = 'metal'

It doesn't look like that is a valid value for the metal field. It should be something like:

SELECT * FROM goldprices WHERE metal = 'Gold'

thanks Ray. There was a problem converting the old php queries to the new ones when I used the new Databridge to update the old version. The issue seemed to be that a query with multiple calls was not converted correctly. It would convert the first query but not the rest. I've copied the old queires below. For some reason, it didn't change the metal types.

Jeff