So I wrote a recursive function for retrieving said tasks from the database.
Code: Select all
private function GetTasks($userId, $parent = 0){
global $database;
$query = "CALL GetTasks($userId, $parent);";
$result = mysql_query($query);
$tasklist = array();
if($result != false){
while($row = mysql_fetch_object($result)){
$task = new Task();
$task->id = $row->id;
$task->text = $row->text;
$task->complete = $row->complete;
$task->parent_id = $row->parent;
$task->children = $this->GetTasks($userId, $task->id);
array_push($tasklist,$task);
}
}
return $tasklist;
}
What can I do to fix this?
Thanks,
-B