bar chart question

[Anon]

hi all,
acn nayone let me know how to make the data from the resultset to be sent in the form of an array in php?
like iam using phplot pacakge to generate graphs but
iam unable to send the data in an array form
i have tried this code but it gives me only the last row of the retrived query.
$sqla has some sql query
$resa = mysql_query($sqla,$conn);
while($row1 = mysql_fetch_array($resa))
{
$proto = $row1["proto"];
$sumsbytes = $row1["sbytes"];
$sumrbytes = $row1["rbytes"];

$data = array("$proto","$sumsbytes","$sumrbytes");
}

here $data contains only the last row of the result why?
please let me know how to populate the contents of result set as an array

any help appreciated
akanksha

[Anon]

hello akanksha,

try this piece of code:

for($i=0;$i<10;$i++)
{
$a=$b=$c=$i;
$data[] = array("$a","$b","$c");
// $data[] is the trick...
}
for($i=0;$i<10;$i++)
{
echo $data[$i][0]." ".$data[$i][1]." ".$data[$i][2]."<br>";
}

hth
chris