building graph with swf flash

[irfani]

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

[johnsquibb]

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.