Система выдает мне ошибку "Warning: mysqli_stmt_bind_param() expects parameter 1 to be mysqli_stmt, boolean given in models/orders.php on line 123
Есть функция "function getOrderTotals()", она подключена к таблице "Orders" и "Cakes" в БД.
function getOrderTotals()
{
global $conn;
$stmt = mysqli_prepare ($conn,
"SELECT (SUM(Cakes.Price) / 1.12) AS BeforeTaxPrice, (SUM(Cakes.Price) / 1.12 * 0.12) AS Tax, SUM(Cakes.Price) AS TotalPrice
FROM INNER JOIN OrdersCakes ON Orders.OrderID = OrdersCakes.OrderID) INNER JOIN Cakes ON OrdersCakes.CakeID = Cakes.CakeID
WHERE Orders.OrderID=?;");
mysqli_stmt_bind_param($stmt, "i", $OrderID); //line 123
$success = mysqli_stmt_execute($stmt); //line 124
$result = mysqli_stmt_get_result($stmt); //line 125
$resultArr = false;
if($success && mysqli_num_rows($result)>=0)
{
$resultArr = mysqli_fetch_all($result, MYSQLI_ASSOC);
}
return $resultArr;
}
ВОТ ВСЕ ОШИБКИ КОТОРЫЕ ВЫДАЕТ СИСТЕМА:
Warning: mysqli_stmt_bind_param() expects parameter 1 to be mysqli_stmt, boolean given in /home/jad/public_html/Cakeshop/models/orders.php on line 123
Warning: mysqli_stmt_execute() expects parameter 1 to be mysqli_stmt, boolean given in /home/jad/public_html/Cakeshop/models/orders.php on line 124
Warning: mysqli_stmt_get_result() expects parameter 1 to be mysqli_stmt, boolean given in /home/jad/public_html/Cakeshop/models/orders.php on line 125
Что мне делать чтобы исправить эти ошибки?