Running a Query with in a foreach loop

[eluser]kgill[/eluser]
Ok quick illustrative example

Code:

// suppose we have 2 queries with the following results

query 1:
proj_ID proj_title
------- -----------
1       foo
2       bar
3       baz
4       qux

query 2:
task_ID proj_id task_desc
------- ------- ----------
1       1       do something
2       1       then do something else
3       1       finish it
1       2       catch fish
2       2       eat fish
1       4       jump
2       4       hop
3       4       skip
4       4       rest

//Using a left join (to make sure you picked up projects with no tasks) you'd get the following:

proj_id proj_name task_no task_desc
------- --------- ------- ----------
1       foo       1       do something
1       foo       2       then do something else
1       foo       3       finish it
2       bar       1       catch fish
2       bar       2       eat fish
3       baz       NULL    NULL
4       qux       1       jump
4       qux       2       hop
4       qux       3       skip
4       qux       4       rest

As you can see the project name & id are going to repeat because each has multiple tasks assigned to it. Once you know that you can just loop through testing for the change.

Code:

//psuedo-code follows
$proj_id = -1;
foreach ($project as $row) {
   if $row->proj_id <> $proj_id { // if the project id changes print something out
     echo $row->proj_name;
     $proj_id = $row->proj_id;
   }
   // print out details for that project name
   echo 'task '. $row->task_no . ' ' . $row->task_desc;
}

Which would result in:

foo
task 1 do something
task 2 then do something else
task 3 finish it
bar
task 1 catch fish
task 2 eat fish
baz
qux
task 1 jump
etc...