Code: Select all
// Compute total spent
$sql = "SELECT SUM(price) AS total FROM purchase";
if ($result = $mysqli->query($sql)) {
if ($mysqli->num_rows()) {
$row = $result->fetch_assoc();
echo $row['total'];
}
} else {
echo $mysqli->error;Fatal error: Call to undefined method mysqli::num_rows()
All help is greatly appreciated. Thanks in advance
[/syntax]