Create array for chart script

Anon

I want to create a variable to put data from a mysql database into the array()slot in a php script that builds a chart. So far I've come up with:

<?
mysql_connect ($host, $user, $password);
$result = mysql($database,"select $field_name, $field_name2 from $table");
$num = mysql_numrows($result);

while ($row = mysql_fetch_array ($result)) {
$arr= "".$row[$field_name]."";

$arr2 = "".$row[$field_name2]."";

}
?>

The problem is that when I plug $arr and &arr2 into the script, the chart only shows the data from the last row in the database.

How can I create variables that will return all of the rows in the database?

Anon

<?
$arr = array();
$arr2 = array();
mysql_connect ($host, $user, $password);
$result = mysql($database,"select $field_name, $field_name2 from $table");
$num = mysql_numrows($result);

$i = 0;
while ($row = mysql_fetch_array ($result)) {
$arr[$i]= $row[$field_name];

$arr2[$i] = $row[$field_name2];
$i++
}
?>

fancao

<?
mysql_connect ($host, $user, $password);
$result = mysql($database,"select $field_name, $field_name2 from $table");
$num = mysql_numrows($result);
while ($row = mysql_fetch_array ($result)) {
$arr[]= $row[$field_name];
$arr2[] = $row[$field_name2];
}
?>

Anon

Craig: Thanks for the suggestion. I plugged your code into the script and hooked up to the graphics library (Graphite). The result was a chart with a single label "Array" and a value of 100. Here is the code that links the php script to the graphite libary. I left the $arr/$arr2 variables intact. Am I missing a step?

Require ("graphite.inc");

$test = new graphite();
$test->filename = "mypng.png";
$test->width = 400;
$test->height = 300;
$test->y_axis_label = "$";
$test->y_lables = xrange(0, 100, 10);
$test->x_axis_label = "Author";
$test->data = array($arr);
$test->data_lables = array($arr2);
$test->init();
$test->prep();
$test->plot(20);
$test->close();
?>

<HEAD>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<TITLE>Graphite</TITLE>
</HEAD>
<BODY>

</BODY>
</HEAD>

Anon

Fancao: I appreciate your suggestion. Basically I get the same result with your code that I get using Craig's. The result is chart with a single label "Array" and a value of 100. This is the code that links the php script to the graphite libary. Am I missing something?

Require ("graphite.inc");

<HEAD>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<TITLE>Graphite</TITLE>
</HEAD>
<BODY>

</BODY>
</HEAD>

Anon

Never mind, I figured it out, so please ignore my earlier response. The full working script now reads:

mysql_connect ($host, $user, $password);
$result = mysql($database,"select $field_name, $field_name2 from $table");
$num = mysql_numrows($result);

Require ("graphite.inc");
$test = new graphite();
$test->filename = "mypng.png";
$test->width = 400;
$test->height = 300;
$test->y_axis_label = "$";
$test->y_lables = xrange(0, 100, 10);
$test->x_axis_label = "Author";
$i = 0;
while ($row = mysql_fetch_array ($result)) {

$test->data[$i] = $row[$field_name];
$test->data_lables[$i] = $row[$field_name2];
$i++;
}
$test->init();

$test->prep();
$test->plot(20);
$test->close();

<HEAD>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<TITLE>Graphite</TITLE>
</HEAD>
<BODY>

</BODY>
</HEAD>

Thanks again for your suggestion. It just took a while for me to see how to incorporate it.

Anon

Please see my response to Craig - I finally figured it out. Thanks again for your help.