Hi ,
I'm new with php and fusioncharts.
I follow step by step and can able render charts as well.
But, I wonder how to make a filter before render a chart to page . I mean make an option for choose parameter and send to php and query data from database
then plot graph out.
my query as below , I need to call data by month.
$strQuery = "select date_format(keepdate,'%d') as keepday ,keepvalue from keeprecord
where keeplocid = 5
and DATE_FORMAT(keepdate,'%M') = 'March'
order by keepdate ";
I'd like to make as file attached.
Thank you
Nont