Hi everyone,
I'm using Google Charts with data from mySQL and it provides the results
the first time. The php page that has the chart and table results has a
dropdown option where the data can be changed. The date updates the mySQL
query using a jquery function. See below.The problem is that the Google
Chart is not updating when a new date range is provided. Can someone tell
me how the chart can be updated on date change. I would imagine it's one
line of code to put into the jquery script.
Thanks
Angel
The Query
$dbDemographicsQuery = "SELECT Race, COUNT(Race) AS totalRace, Ethnicity
FROM Greeter_Detail
WHERE $dateRange
GROUP BY Race";
JQ used to update dates:
$('#month, #year').on('change', function() {
var url = window.location.href;
url += '?month=' + $('#month').val();
url += '&year=' + $('#year').val();
$('#table-data').load(url + ' #table-data > *');
});
--
You received this message because you are subscribed to the Google Groups
"Google Visualization API" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/google-visualization-api/eb5b2c6d-5b77-414d-af85-428ca1de2b89n%40googlegroups.com.
