Grouping query results

[Bill_VA]

Admittedly I'm new to PHP, I'm a ColdFusion guy from way back.  And something that I'd could easily do with a <cfoutput group="catID"> tag and another nested <cfoutput> tag is kicking my butt.

 

I have the following data returned from a query:

 

catID  catName   catOrder  calOwnerID  calOwnerName 

7       Baseball     2            3                Some League

7       Baseball     2            9                Another League

7       Baseball     2            10              Test League

9       Football     1            7                This League

 

I want to generate html that looks like this, but I can't seem to get it:

 

<ul id="menu">

  <li>Baseball

    <ol>

      <li><a href="#">Some League</a></li>

      <li><a href="#">Another League</a></li>

      <li><a href="#">Test League</a></li>

    </ol>

  </li>

  <li>Football

    <ol>

      <li><a href="#">This League</a></li>

    </ol>

  </li>

</ul>

[jguy]

do a foreach loop to build the list

[Bill_VA]

Again, I'm a rookie.  Please explain a foreach loop, an example would be great.

[Waldir]

http://us.php.net/foreach

[Waldir]

<?
		while($row = mysql_fetch_array($results_of_query)) {
				$echo "link structure for example $row[calOwnerName]";
			}
	?>