$resultX = "SELECT DATE_FORMAT(FROM_UNIXTIME(`DPDDat`), '%m.%Y') AS 'komplett', DATE_FORMAT(FROM_UNIXTIME(`DPDDat`), '%m') AS 'Monat',DATE_FORMAT(FROM_UNIXTIME(`DPDDat`), '%Y') AS 'Jahr',id,DPDDat FROM `dbo.Sicht_AlleDPDDaten` WHERE DPDDat >= '01.2020' and DPDDat <= '03.2020' GROUP BY DATE_FORMAT(FROM_UNIXTIME(`DPDDat`), '%m %Y') ORDER BY DPDDat ASC";
$monate = array();
$pakete = array();
$statement2 = $pdo->prepare("SELECT COUNT(*) AS anzahl FROM dbo.Sicht_AlleDPDDaten WHERE DPDDat >= '01.2020' and DPDDat <= '03.2020' AND DATE_FORMAT(FROM_UNIXTIME(`DPDDat`), '%m.%Y') = '$komplett'");
Einen Kommentar schreiben: