function finishGame($outcome) {
$query = "UPDATE stats SET outcome = ? WHERE id = ?";
$statement = $this->connection->prepare($query);
$statement->bind_param("si", $outcome, $this->currentSession);//Issue here
$statement->execute();
$statement->close();
}
mysql> describe games;
+-------------+-------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+-------------+-------------+------+-----+---------+----------------+
| id | int(12) | NO | PRI | NULL | auto_increment |
| name | varchar(20) | NO | | NULL | |
| date_played | datetime | NO | | NULL | |
| difficulty | tinyint(4) | YES | | NULL | |
| outcome | varchar(20) | NO | | NULL | |
+-------------+-------------+------+-----+---------+----------------+
5 rows in set (0.00 sec)
Fatal error: Call to a member function bind_param() on a non-object
I can't figure out the mistake causing the non-object error despite knowing it's likely related to my SQL query.