displaying search results in a non repeating way

[Jim_Madrid]

PHP & MYSQL

I have a taxonomic database of animal species (phylum, class, order, family, species, etc) and would like to know if there is a way to display search results without repeating each category for each species. In other words, I want to avoid example 1 and achieve example 2. That is, if the name of the species changes but the prior categories stay the same I don´t want to repeat every category.

Example 1 NO!

Class Order Family Species 1
Class Order Family Species 2
Class Order Family Species 3
Class Order 2 Family 2 Species 4
Class Order 2 Family 2 Species 5
Class Order 2 Family 2 Species 6
Class Order 2 Family 3 Species 7
Class Order 2 Family 3 Species 8

Example 2 YES!

Class Order Family Species 1
Species 2
Species 3
Order 2 Family 2 Species 4
Species 5
Species 6
Family 3 Species 7
Species 8


Any ideas would be greatly appreciated.

James

[Pig]

PHP Code:

$result = mysql_query("SELECT * FROM table_name")
while( $row = mysql_fetch_array($result) )
     {
     $row0 = $row[0];
     $row1 = $row[1]
     $row2 = $row[2]
     $row3 = $row[3]

     if( $row0 == $row0set )
          {
          unset($row0);
          }
     if( $row1 == $row1set )
          {
          unset($row1);
          }
     if( $row2 == $row2set )
          {
          unset($row2);
          }

    echo("
          $row0, $row1, $row2, $row3
            ");
     $row0set = $row0;
     $row1set = $row1;
     $row2set = $row2;    
     }


Someone try that and see if it works. I'm at work and cant do it from here.

The idea is that if a new items comes along, it'll be printed, other wise it gets blanked. That is, a new value for $rowX will keep it from being unset, and every identical one after that will match, and there fore get unset.

Lemme know if that worked.