Help, How to pass an array value from database

[eluser]Unknown[/eluser]
Sorry, I'm newbie

I want to use 3d-pie-cart, How to pass an array ($query) from the database to the method $this->piechart->setData($mydata); and setLabels($mylabel);. btw setLabels() and setData() must an array.

Code:

$this->load->library('piechart');
$query = $this->supermodel->grafik($start,$end);
        
$mylabel = array();
$mydata = array();

foreach ($query->result() as $row){
   $mylabel[] = array($row->mylabel); //result String, is this code, correct?
   $mydata[] = array($row->mydata);  //result integer, is this code, correct?
}
        
// Set variables etc
$this->piechart->showLabel(true);
$this->piechart->showPercent(true);
$this->piechart->showParts(true);
$this->piechart->setWidth(250);
$this->piechart->setLegend('round');
$this->piechart->setData($mydata); // This is an array
$this->piechart->setLabels($mydata); // This is an array

// Make unique filename
$hash = md5("report-pie-$start-$end");

// Generate pie and save it
$this->piechart->Generate("c:/xampp/htdocs/skripsi/images/reports/$hash.png");
$basis = base_url();        
$data['graph'] = $hash.'.png';
        
$this->load->view('admin/report_view',$data);

it's give me an error.
A PHP Error was encountered

Severity: Warning

Message: Division by zero

Filename: libraries/Piechart.php

Line Number: 124




Thanks for answering my question.
I'm sorry, my english is poor.

[eluser]pickupman[/eluser]
You are creating an multidimensional array. Try using instead:

Code:

foreach ($query->result() as $row){
   $mylabel[] = (string)$row->mylabel; //result String, is this code, correct?
   $mydata[] = (int)$row->mydata;  //result integer, is this code, correct?
}

[eluser]Unknown[/eluser]
[quote author="pickupman" date="1293234883"]You are creating an multidimensional array. Try using instead:

Code:

foreach ($query->result() as $row){
   $mylabel[] = (string)$row->mylabel; //result String, is this code, correct?
   $mydata[] = (int)$row->mydata;  //result integer, is this code, correct?
}

[/quote]


Great!!! This code work for me
Thank you very much, I can't find how to thank you, thanks for pickupman