Ten drugi jest pod spodem (gdy kasuje ten pierwszy dziala drugi). Chce by byly dwa lub wiecej jednoczesnie.. Czy wgl jest to jeszczcze mozliwe?
BODY
JS
<script type="text/javascript" src="https://www.gstatic.com/charts/loader.js"></script>
<?php $query1 ="SELECT ".$prefix."categories.categories_name, COUNT(".$prefix."categories.categories_name) as count FROM ".$prefix."news LEFT JOIN ".$prefix."newscategories ON ".$prefix."news.news_id = ".$prefix."newscategories.news_id LEFT JOIN ".$prefix."categories ON ".$prefix."categories.categories_id = ".$prefix."newscategories.categories_id GROUP BY ".$prefix."categories.categories_id "; ?> <script type="text/javascript"> //WYKRES NR1 google.charts.load("visualization", "1", {'packages':['corechart']}); google.charts.setOnLoadCallback(drawChart); function drawChart() { // Create the data table. var data = new google.visualization.DataTable(); data.addColumn('string', 'Topping'); data.addColumn('number', 'Slices'); data.addRows([ <?php while($r1 = mysqli_fetch_assoc($result1)) { } ?> ]); var options = {'title':'Statystyka ogłoszeń', 'width':400, 'height':300}; var chart = new google.visualization.PieChart(document.getElementById('chart1')); chart.draw(data, options); } </script> <?php $query2 =" SELECT ".$prefix."rank.rank_name, COUNT(".$prefix."rank.rank_name) as count FROM ".$prefix."users LEFT JOIN ".$prefix."rank ON ".$prefix."rank.rank_id = ".$prefix."users.rank_id GROUP BY ".$prefix."rank.rank_id "; ?>
<script type="text/javascript"> //WYKRES NR2 google.load('visualization', '1.0', {'packages':['corechart']}); // Set a callback to run when the Google Visualization API is loaded. google.setOnLoadCallback(drawChart); function drawChart() { // Create the data table. var data = new google.visualization.DataTable(); data.addColumn('string', 'Topping'); data.addColumn('number', 'Slices'); data.addRows([ <?php while($r2 = mysqli_fetch_assoc($result2)) { } ?> ]); var options = {'title':'Statystyka użytkowników', 'width':400, 'height':300}; var chart = new google.visualization.PieChart(document.getElementById('chart2')); chart.draw(data, options); } </script>