Unordered Listing of a Query

[jessjenn]

I have two tables joined in a query: project and task. A project has many tasks and they are joined by projectid. This is my query:

select project.projectname, task.taskname
from project, task
where project.projectid = task.projectid

What I'm trying to do is list them in an unordered list as follows:

<ul>
<li>Project 1 
<ul>
<li>Task 1</li>
<li>Task 2</li>
<li>Task 3</li>
</ul>
</li>
<li>Project 2 
<ul>
<li>Task 4</li>
<li>Task 5</li>
<li>Task 6</li>
</ul>
</li>
</ul>

Of course, Project 2 wouldn't be the last project. It'll be for an X number of projects and tasks. How would I loop through this in PHP? Thanks.

[TheIceman5]

search for mysql_fetch_row()

[jessjenn]

Thanks for the reply but I've been using mysql_fetch_row unsuccessfully. If there's more than one project assigned to a task, then the project is listed again, which I do not want. This is a simplified version of my code:

for ($count = 1; $row = mysql_fetch_row ($conn1->getResult()); $count++)   {   

   print "$row[0]<br>"; 
   print "&nbsp;&nbsp;&nbsp;$row[1]<br><br>";      

} 

With that, all I get is a project name and under it, only one task. If there are other tasks assigned to the project, it gets written again. Such as:

Project 1
   Task 1
Project 1
   Task 2
Project 1
   Task 3
Project 2
   Task 1
Project 1
   Task 4

What I want is this:

Project 1
   Task 1
   Task 2
   Task 3
   Task 4
Project 2
   Task 1

Any thoughts? Thanks.

[jessjenn]

I got it to work. Thanks for the tremendous help!