De volgende code geeft nog steeds 31 (of) 30 rijen ipv 2x 15
Door $kolom de waarde 1 of 2 te geven probeer ik naar een nieuwe regel of naar het deel te gaan.
Ergens maak ik nog een denk fout.
$dbegin = 2013 ;
$deind = date("Y") ;
$sql = "" ;
$sql = "SELECT Dag AS Dag, " ;
while ($dbegin <= $deind) {
$sql = $sql . "SUM(CASE Jaar WHEN " . (string)$dbegin . " THEN Levering END) AS '" . (string)$dbegin . "'" ;
if ($dbegin < $deind) {
$sql = $sql . " , " ;
} else {
break ;
}
$dbegin = $dbegin + 1 ;
} ;
$sql = $sql . " FROM tbl_Levering INNER JOIN tbl_EParameter ON (Maand = tbl_EParameter.ZMaand) GROUP BY Dag ORDER BY Dag" ;
$result = mysqli_query($con,$sql) ;
$dbegin = 2013 ;
$lengte = (($deind-2013) * 95* 2 ) + 150 ;
$header = "<table border '1', width='" . (string)$lengte ."'>" ;
$header = $header . "<tr> <th width='60' scope='col'>Dag</th>" ;
$header1 = "<th width='10'></th> <th width='60' scope='col'>Dag</th> " ;
while ($dbegin <= $deind) {
$header = $header . "<th width='95' scope='col'>" . (string)$dbegin . "</th>" ;
$header1 = $header1 . "<th width='95' scope='col'>" . (string)$dbegin . "</th>" ;
if ($dbegin>$deind) {break ;
}
$dbegin = $dbegin + 1 ;
} ;
$header = $header . $header1 . "</tr>";
echo $header;
$dbrow = mysqli_fetch_all($result,MYSQLI_BOTH) ;
$kolom = 1 ;
foreach ($dbrow as $row) {
$dbegin = 2013 ;
echo "<tr>";
echo "<td><div align='center'>", $row['Dag'], "</td>";
while ($dbegin <= $deind) {
echo "<td><div align='right'>", $row[(string)$dbegin] ,"</td>";
if ($dbegin>$deind) {break;
}
$dbegin = $dbegin + 1 ;
} ;
if ($kolom == 1) {echo "<td> </td>";
$kolom = 2 ;
} else {echo "</tr>";
$kolom = 1 ;
}
} ;
echo "</table>";
mysqli_close($con);