Getting mysql data to work with array script.

[xwishmasterx]

Sorry for the not-so-clear head line.

 

I need some help with an existing script that uses array to display af graph.

The existing script is as below:

 

 

$p->data = array(
array(array("2010-10-01",48.25),array("2010-01-01",238.75),array("2011-01-01",95.50)),
array(array("2010-10-01",14.25),array("2010-10-4",438.75),array("2010-10-6",125.50))
);

The two lines in bold are each af line consisting of 3 points.

 

The question is how can I get the data form my database to match such a line?

EG: Column: DATE, A,B should be able to output

 

array(array("DATE",A),array("DATE",A),array("DATE",A)),

array(array("DATE",B),array("DATE",B),array("DATE",B)),

 

(assuming I have 3 values of each ofcourse).

 

Any help will be appreciated.

 

 

 

[Barand]

try

$conn = new mysqli(HOST,USERNAME,PASSWORD,'test');

$data = array();
$sql = "SELECT date, a, b
        FROM mytable";
$res = $conn->query($sql);
while (list($date, $a, $b) = $res->fetch_row()) {
    $data['A'][] = array($date, $a);
    $data['B'][] = array($date, $b);
}