I'm trying to build a SELECT that shows all the sum of the dates. Example:
2019-05-10 - 10.00
2019-05-10 - 10.00
2019-01-01 - 1.00
The loop need to show:
2019-05-10 - total: 20.00
2019-01-01 - total: 1.00
i already try but.. i need the SELECT SUM
to complete it...
I need to show the DATE + SUMValue.
$support_sales = $con->prepare("");
$support_sales->execute();
$support_sales->bind_result();
$support_sales->store_result();
while($support_sales->fetch()) {}
I tried
$con = new mysqli($dbServername, $dbUsername, $dbPassword, $dbName);
if ($con->connect_error) {
die("Connection failed: " . $con->connect_error);
}
$support_sales = $con->prepare("SELECT budget_date SUM(budget_price) FROM public_budgets WHERE budget_status = 1 GROUP BY budget_date");
$support_sales->execute();
$support_sales->bind_result($budget_date, $total);
$support_sales->store_result();
while($support_sales->fetch()) {
echo $budget_date.$total;
}
error: Fatal error: Uncaught Error: Call to a member function execute() on boolean in /var/www/html/asp/inc/csv_excel_statistics_sales.php:47 Stack trace: #0 {main} thrown in /var/www/html/asp/inc/csv_excel_statistics_sales.php on line 47