Create line chart from MySQL table using Google Charts

I have a table in MySQL with the columns 'temperature', 'moisture' and 'date'. I would like to present this on a line chart using Google Charts, however the difficulty I'm facing is formatting my array of values from the database so that it can be used in a Google chart; as a Google Charts expert you'll know for sure that this DataTable has to be formatted in 'cols' and 'rows'. On the x-axis would be date, which is formatted date('Y/m/d H:i:s'), and on the y-axis will be temperature and moisture. I would also like for this line chart to update itself every 60 seconds to reflect new data saved in the database, without having to reload the entire page. New data points should appear on the chart in real time, with old data points automatically scrolling out of view. Apparently you can use $.ajax and setInterval to simulate real time updates, but maybe you know a better way? I'm expecting that this could be done within a couple of hours and I would like it done as soon as possible please, great opportunity for someone adept at Google Charts to earn a little extra cash.