CODEWITHSUNDEEP
phpmysqlsql
IRAP
IRAP

Reputation: 1

How to show the related tasks list from the table?

I need help. I have table name called "Tasks", below 

SNO Taskname parentid
---------------------
46  Task-1     0
47  Task-2    46
48  Task-3    47
49  Task-4    46
50  task-5    47
51  task-6    50

For example, I am in Task page 48, now we would show the related Tasks no. of 48. So, the output would be 46,47,49,50,51.

I tried the code below, but it does not work:

function getTask($task_id) {                    
    $rs=mysql_query("select task_id,taskname,p_id from task where task_id='".$task_id."'");
    $rs_req=mysql_fetch_array($rs) or die(mysql_error());                    
    $reqt=$rs_req['p_id'];                   
    return $reqt;   
}

$task = getTask($task_id);               
$pid = $task;
$related_tasks = [];                

while ($pid != 0) {                 
    $pid = getTask($pid);
    $relatedTasks[] = $pid;
}

print_r($relatedTasks);

Upvotes: 0

Views: 62

Answers (1)

gotha
gotha

Reputation: 489

Relational databases are not meant to deal with recursive queries.

You can do it by selecting the first the row with ID 48 and then recursively check of parentId != 0 and execute another query if so. Something like

$task = getTask(48);
$related_tasks = [];
while( $task['parentID'] != 0) {
    $task = getTask( $task['parentId']);
    $relatedTasks[] = $task;
}

Take a look at How to create a MySQL hierarchical recursive query.

Upvotes: 1

Related Questions