Trying to turn this data retrieved from mysql database into a chart or
graph.
Here my code queries the database and displays it as a table, i want to
also display it as a chart underneath the table. I have read all the google
doc information still can not grasp this. Can someone help.
Thanks
<?php
//formula for toner usage total pages/35000 = #toner used for month
if(isset($_POST["YEAR"])) {
$year = $_POST['YEAR'];
$result = mysqli_query($dbhandle,"SELECT `Servers`, `Total Pages` / 35000
FROM summaryofserver WHERE
RIGHT(Servers,4) = '$year'");
$result2 = mysqli_query($dbhandle, "SELECT SUM(`Total Pages` / 35000) FROM
summaryofserver WHERE
RIGHT(Servers,4) = '$year'");
echo "<table border='1'>
<tr>
<th>Server, Month, Year</th>
<th>Number of Toner Cartridges Used</th>
</tr>";
while($row = mysqli_fetch_array($result)) {
echo "<tr>";
echo "<td>" . $row[0] . "</td>";
echo "<td>" . $row[1] . "</td>";
echo "</tr>";
}
$sum = mysqli_fetch_array($result2);
echo "<tr>";
echo "<td>" .'Total for Year:'. $year. "</td>";
echo "<td>" . $sum[0] . "</td>";
echo "</tr>";
echo "</table>";
}
?>
--
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 post to this group, send email to [email protected].
Visit this group at http://groups.google.com/group/google-visualization-api.
For more options, visit https://groups.google.com/d/optout.
