I see where it has even updated my variables on the page. I am surprised! Wow.
<td align="right">$<?php echo number_format (($GoldPrices->getColumnVal('price') * $GoldPrices->getColumnVal('rate') * 0.416), 2) ; ?></td>
But even with everything updated and it seem to show in part on live page view, when uploaded it is drawing a blank page. And I have uploaded the rsobj and the connection script.
Okay thanks. But I may be losing something when I update.
This is the new recordset:
<?php
$GoldPrices = new WA_MySQLi_RS("GoldPrices",$LiveGold_i,1);
$GoldPrices->setQuery("SELECT * FROM goldprices WHERE metal = 'Gold'");
$GoldPrices->execute();
?>
This was the OLD recordset. I will lose all the variables it created it think: ?
mysql_select_db($database_LiveGold, $LiveGold);
$query_GoldPrices = "SELECT * FROM goldprices WHERE metal = 'Gold'";
$GoldPrices = mysql_query($query_GoldPrices, $LiveGold) or die(mysql_error());
$row_GoldPrices = mysql_fetch_assoc($GoldPrices);
$totalRows_GoldPrices = mysql_num_rows($GoldPrices);
Is the update not picking up the specific queries? Or has it changed that much?
The output I have on that page currently is using variables created under the old queries:
<td align="right">$<?php echo number_format (($row_GoldPrices['price'] * $row_GoldPrices['rate'] * 0.416), 2) ; ?></td>