bukan solusi query

<?php
    error_reporting(0);
$data="
CN235   12-01-02    100
CN235   12-01-05    120
CN235   12-01-12    140
CN235   12-01-11    150
CN236   12-01-11    200
CN235   12-01-15    160
CN235   12-01-17    170
CN235   12-01-16    180
CN236   12-01-14    200
CN236   12-01-12    400
CN236   12-01-15    120
CN236   12-01-17    400
CN236   12-01-18    600
CN236   12-01-05    800
";
$a=explode("\n",$data);
/*
MASUKKAN KE ARRAY.. asumsikan datanya kayak di atas
*/
foreach($a as $dt)
{
    $a2=explode("\t",$dt);
        if($a2[1]=='') continue;
/* di dalam script anggap
$a2[0]= prod_id .. bs diganti dengan nama atau apalah
$a2[1]= tanggal.. saran saya pake format YYYY-mm-dd
$a2[2]= nilainya
*/
    //$aName[$a2[0]]++; //pro_id
    $aDt[$a2[1]]++; //tanggal yang muncul
    $aData[$a2[0]][$a2[1]]=$a2[2];
}

/*
MUNCULKAN!!
*/
$s='<table border=1>';
$s.="\n<tr>";
$s.="<td>&nbsp;</td>";
    ksort($aDt);reset($aDt);
    foreach($aDt as $date=>$val)
    {
/*=============Saranku lebih baik tanggalnya di konversi jadi
tanggal yg bener dan sesuai keinginan========*/
        $s.="\n\t<td>$date</td>";
    }
$s.="\n<tr>";
foreach($aData as $id=>$aVal)
{
    if(count($aVal)==1) continue;
    $s.="\n<tr>";
    $s.="<td>$id&nbsp; ".count($aVal)."</td>";
    ksort($aDt);reset($aDt);
    foreach($aDt as $date=>$val)
    {
        $s.="\n\t<td>".$aVal[$date]."&nbsp;</td>";
    }
    $s.="\n<tr>";
}
$s.="</table>";
print $s;