i try to building graph with charts swf (flash)
from query table i have 2 field like year,num,

i want result from script like this
$chart [ 'chart_data' ][ 0 ][ 0 ] = "";
$chart [ 'chart_data' ][ 0 ][ 1 ] = "2001";
$chart [ 'chart_data' ][ 0 ][ 2 ] = "2002";
$chart [ 'chart_data' ][ 0 ][ 3 ] = "2003";
$chart [ 'chart_data' ][ 0 ][ 4 ] = "2004";
$chart [ 'chart_data' ][ 1 ][ 0 ] = "Drop Call";
$chart [ 'chart_data' ][ 1 ][ 1 ] = 5;
$chart [ 'chart_data' ][ 1 ][ 2 ] = 10;
$chart [ 'chart_data' ][ 1 ][ 3 ] = 30;
$chart [ 'chart_data' ][ 1 ][ 4 ] = 63;

=====

i try to make script like this

$chart [ 'chart_data' ][ 0 ][ 0 ] = "";
$chart [ 'chart_data' ][ 1 ][ 0 ] = "Drop Call";
$bar=1;
while($row = mysql_fetch_array($resultmoto))
{
$data[] = $row[1];
$leg[] = $row[0];
$chart [ 'chart_data' ][ 0 ][ $bar ] = $data;

$chart [ 'chart_data' ][ $row ][ $bar ] = $leg,
$bar++;
}


but the result still cannot display.
please check

tx

try changing your code like this:

while($row = mysql_fetch_array($resultmoto))
{
	$data = $row[1];
	$leg = $row[0];
	$chart [ 'chart_data' ][ 0 ][ $bar ] = $data;
	
	$chart [ 'chart_data' ][ $row ][ $bar ] = $leg;
	$bar++;
}

changes: made 'data' and 'leg' flat variables instead of arrays, changed comma to semicolon toward end of loop.

$row[0] and $row[1] are going to be the first and second columns in your table respectively...make sure that is the data you want to pull, otherwise call the columns by their associative name, such as $row.

This article has been dead for over six months. Start a new discussion instead.