Hi guys,
I tried to create a column chart with the following code
<? $sth3 = mysql_query("SELECT count(t.tn) AS Tickets, q.name AS Queue FROM
ticket t, queue q WHERE t.queue_id=q.id AND t.ticket_state_id IN
(1,4,6,7,8) GROUP BY q.name");
$rows = array();
//flag is not needed
$flag = true;
$table = array();
$table['cols'] = array(
array('label' => 'Queue', 'type' => 'string'),
array('label' => 'Tickets', 'type' => 'number')
);
$rows = array();
while($r = mysql_fetch_assoc($sth3)) {
$temp = array();
$temp[] = array('v' => (string) $r['Queue']);
$temp[] = array('v' => (int) $r['Tickets']);
$rows[] = array('c' => $temp);
}
$table['rows'] = $rows;
$jsonTable3 = json_encode($table); ?>
..........
function drawChart3() {
// Create our data table out of JSON data loaded from server.
var data = new
google.visualization.arraytoDataTable(<?=$jsonTable3?>);
var options = {
title: 'Company Performance',
hAxis: {title: 'Year', titleTextStyle: {color: 'black'}},
width: 1000,
height: 600,
};
var chart = new
google.visualization.ColumnChart(document.getElementById('chart_div3'));
chart.draw(data, options);
}
.......
But I'll get every time
*Warning*: mysql_fetch_assoc() expects parameter 1 to be resource, boolean
...
This codes works fine with the pie chart :( Any idea?
--
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 google-visualization-api+unsubscr...@googlegroups.com.
To post to this group, send email to google-visualization-api@googlegroups.com.
Visit this group at http://groups.google.com/group/google-visualization-api.
For more options, visit https://groups.google.com/d/optout.
