este es el codigo que estoy usando.
archivo 1 el que obtiene los datos
Código PHP:
//include charts.php to access the InsertChart function
include "charts.php";
//change the chart to a bar chart
$chart [ 'chart_type' ] = "LINE";
//start the PHP multi-dimensional array and create the region titles
$chart [ 'chart_data' ][ 0 ][ 0 ] = "";
$chart [ 'chart_data' ][ 1 ][ 0 ] = "2005";
$chart [ 'chart_data' ][ 2 ][ 0 ] = "2006";
$chart [ 'chart_data' ][ 3 ][ 0 ] = "2007";
//connect to the database
mysql_connect ( "localhost", "root", "" );
mysql_select_db ( "oportunidad" );
//get the smallest year to determine which year to start the chart with
$result = mysql_query ( "SELECT MIN(DIA) AS MinDIA FROM MOVIMIENTO" );
$MinMES = mysql_result ( $result, 0, "MinDIA" );
//get all the data in the Growth table
$result = mysql_query ("SELECT *
FROM MOVIMIENTO
WHERE AREA ='ODONTOLOGIA GENERAL' AND MES ='1'AND SEDE='TUNJA'
ORDER BY DIA ASC");
//extract the data from the query result one row at a time
for ( $i=0; $i < mysql_num_rows($result); $i++ ) {
//determine which row in the PHP array the current data belongs to
switch ( mysql_result ( $result, $i, "AÑO" ) ) {
case "2005":
$row = 1;
break;
case "2006":
$row = 2;
break;
case "2007":
$row = 3;
break;
}
//determine which column in the PHP array the current data belongs to
$col = mysql_result ( $result, $i, "DIA") - $MinDIA + 1;
//populate the PHP array with the Year title
$chart [ 'chart_data' ][ 0 ][ $col ] = mysql_result ( $result, $i, "DIA");
//populate the PHP array with the revenue data
$chart [ 'chart_data' ][ $row ][ $col ] = mysql_result ( $result, $i, "OPORTUNIDAD");
}
//send the new data to charts.swf
SendChartData ( $chart );
?>
archivo dos el que realiza la grafica
Código PHP:
<?php
include "charts.php";
/*
* aqui le dices que inserte un objeto de flash y que obtenga los datos del archivo datos.php
* los ultimos numeros indican ancho y altura del objeto
*/
echo InsertChart ( "charts.swf", "/GRAFICOS/charts_library", "oport_od_2_t.php", 800, 300, "A8C4F2", false );
?>
y los datos de la tabla son los siguientes
Código PHP:
seg_ing SEDE AREA AÑO MES DIA OPORTUNIDAD
------- ------ ------------------- ------ ------ ------ -----------
(NULL) TUNJA ODONTOLOGIA GENERAL 2006 1 2 36
(NULL) TUNJA ODONTOLOGIA GENERAL 2007 1 2 24
(NULL) TUNJA ODONTOLOGIA GENERAL 2005 1 3 72
(NULL) TUNJA ODONTOLOGIA GENERAL 2006 1 3 24
(NULL) TUNJA ODONTOLOGIA GENERAL 2007 1 3 24
(NULL) TUNJA ODONTOLOGIA GENERAL 2005 1 4 72
(NULL) TUNJA ODONTOLOGIA GENERAL 2006 1 4 24
(NULL) TUNJA ODONTOLOGIA GENERAL 2007 1 4 24
(NULL) TUNJA ODONTOLOGIA GENERAL 2005 1 5 72
(NULL) TUNJA ODONTOLOGIA GENERAL 2006 1 5 24
(NULL) TUNJA ODONTOLOGIA GENERAL 2007 1 5 24
(NULL) TUNJA ODONTOLOGIA GENERAL 2005 1 6 72
(NULL) TUNJA ODONTOLOGIA GENERAL 2006 1 6 36
(NULL) TUNJA ODONTOLOGIA GENERAL 2007 1 6 24
(NULL) TUNJA ODONTOLOGIA GENERAL 2005 1 7 72
(NULL) TUNJA ODONTOLOGIA GENERAL 2007 1 7 24
(NULL) TUNJA ODONTOLOGIA GENERAL 2005 1 8 72
(NULL) TUNJA ODONTOLOGIA GENERAL 2007 1 8 24
(NULL) TUNJA ODONTOLOGIA GENERAL 2007 1 9 24
(NULL) TUNJA ODONTOLOGIA GENERAL 2006 1 10 24
(NULL) TUNJA ODONTOLOGIA GENERAL 2007 1 10 24
(NULL) TUNJA ODONTOLOGIA GENERAL 2005 1 11 36
(NULL) TUNJA ODONTOLOGIA GENERAL 2006 1 11 24
(NULL) TUNJA ODONTOLOGIA GENERAL 2007 1 11 24
(NULL) TUNJA ODONTOLOGIA GENERAL 2005 1 12 36
(NULL) TUNJA ODONTOLOGIA GENERAL 2006 1 12 36
(NULL) TUNJA ODONTOLOGIA GENERAL 2007 1 12 24
(NULL) TUNJA ODONTOLOGIA GENERAL 2005 1 13 36
(NULL) TUNJA ODONTOLOGIA GENERAL 2006 1 13 36
(NULL) TUNJA ODONTOLOGIA GENERAL 2007 1 13 24
(NULL) TUNJA ODONTOLOGIA GENERAL 2005 1 14 24
(NULL) TUNJA ODONTOLOGIA GENERAL 2005 1 15 24
(NULL) TUNJA ODONTOLOGIA GENERAL 2007 1 15 24
(NULL) TUNJA ODONTOLOGIA GENERAL 2006 1 16 36
(NULL) TUNJA ODONTOLOGIA GENERAL 2007 1 16 24
(NULL) TUNJA ODONTOLOGIA GENERAL 2005 1 17 48
(NULL) TUNJA ODONTOLOGIA GENERAL 2006 1 17 36
(NULL) TUNJA ODONTOLOGIA GENERAL 2007 1 17 24
(NULL) TUNJA ODONTOLOGIA GENERAL 2005 1 18 48
(NULL) TUNJA ODONTOLOGIA GENERAL 2006 1 18 36
(NULL) TUNJA ODONTOLOGIA GENERAL 2007 1 18 24
(NULL) TUNJA ODONTOLOGIA GENERAL 2005 1 19 48
(NULL) TUNJA ODONTOLOGIA GENERAL 2006 1 19 36
(NULL) TUNJA ODONTOLOGIA GENERAL 2005 1 20 24
(NULL) TUNJA ODONTOLOGIA GENERAL 2006 1 20 48
(NULL) TUNJA ODONTOLOGIA GENERAL 2007 1 20 24
(NULL) TUNJA ODONTOLOGIA GENERAL 2005 1 21 24
(NULL) TUNJA ODONTOLOGIA GENERAL 2005 1 22 24
(NULL) TUNJA ODONTOLOGIA GENERAL 2007 1 22 24
(NULL) TUNJA ODONTOLOGIA GENERAL 2006 1 23 36
(NULL) TUNJA ODONTOLOGIA GENERAL 2007 1 23 24
(NULL) TUNJA ODONTOLOGIA GENERAL 2005 1 24 24
(NULL) TUNJA ODONTOLOGIA GENERAL 2006 1 24 36
(NULL) TUNJA ODONTOLOGIA GENERAL 2005 1 25 24
(NULL) TUNJA ODONTOLOGIA GENERAL 2007 1 25 24
(NULL) TUNJA ODONTOLOGIA GENERAL 2005 1 26 24
(NULL) TUNJA ODONTOLOGIA GENERAL 2007 1 26 24
(NULL) TUNJA ODONTOLOGIA GENERAL 2005 1 27 24
(NULL) TUNJA ODONTOLOGIA GENERAL 2006 1 27 36
(NULL) TUNJA ODONTOLOGIA GENERAL 2007 1 27 24
(NULL) TUNJA ODONTOLOGIA GENERAL 2005 1 28 24
(NULL) TUNJA ODONTOLOGIA GENERAL 2005 1 29 24
(NULL) TUNJA ODONTOLOGIA GENERAL 2007 1 29 24
(NULL) TUNJA ODONTOLOGIA GENERAL 2006 1 30 36
(NULL) TUNJA ODONTOLOGIA GENERAL 2007 1 30 24
(NULL) TUNJA ODONTOLOGIA GENERAL 2005 1 31 24
(NULL) TUNJA ODONTOLOGIA GENERAL 2006 1 31 36
(NULL) TUNJA ODONTOLOGIA GENERAL 2007 1 31 24