I'm trying to figure out the magic to create a line chart from database. I cant seem to figure the magic json format to use. The example shows this data. I have created tables in the database to replicate this data, but I cant figure out the steps to get it from a mysql table into a datastore in the same format that the command below does it.

ANy help with be apprciated.

$category_amount = array(
    array("category"=>"Books","sale"=>32000,"cost"=>20000,"profit"=>12000),
    array("category"=>"Accessories","sale"=>43000,"cost"=>36000,"profit"=>7000),
    array("category"=>"Phones","sale"=>54000,"cost"=>39000,"profit"=>15000),
    array("category"=>"Movies","sale"=>23000,"cost"=>18000,"profit"=>5000),
    array("category"=>"Others","sale"=>12000,"cost"=>6000,"profit"=>6000),
);

<?php
Line::create(array(
    "dataSource"=>$category_amount,
    "columns"=>array(
        "category",
        "sale"=>array("label"=>"Sale","type"=>"number","prefix"=>"$"),
        "cost"=>array("label"=>"Cost","type"=>"number","prefix"=>"$"),
        "profit"=>array("label"=>"Profit","type"=>"number","prefix"=>"$"),
    )
));
?>