Show a last 12 months chart with php mysql

[aMoN75]

Hello,

I need to render a chart with php/mysql from this table :

We need to show a X axis (LAST 12 months) and Y axis (number of cliks with the same id_aff) `

If someone can help me, thanx a lot.
AmoN

[aMoN75]

My code :

[Manoj Mohan]

AmoN,

You are passing values instead of y within $dataPoints. Replacing $dataPoints[0] = array("value" => $row["values"], "label"=> $row["date(timestamp)"]) with $dataPoints[0] = array("y" => $row["values"], "label"=> $row["date(timestamp)"]) should work fine in this case.

—-
Manoj Mohan
Team CanvasJS