public function getLists()
{
$query = 'SELECT projects.name as project, tasks.name, tasks.status
FROM projects
INNER JOIN tasks
ON projects.id=tasks.projects_id
ORDER BY projects.id;';
parent::connectDataBase($query);
$lists = parent::getMySqlResult();
var_dump($lists);
$newLists = array();
foreach ($lists as $index => $array) {
if (!array_search($array['project'], $newLists[$index])) {
$newLists[$index]['project'] = $array['project'];
$newLists[$index]['tasks'] = array('name' => $array['name'], 'status' => $array['status']);
}
}
parent::responseJSON($newLists);
var_dump($newLists);
}
