While Loops????? Need Help

[jmhall09]

I am returning values from a table the list Golf Course Name and the State it is in. It is ordered by State, Golf Couse Name. I am trying to display it to where the state shows once and lists the Golf Course Name below each state. How do I do it to where I look through to see if the state is the same. If so then just write out the course name. If the state is not the same, write the state out then the golf course names.

Thanks In Advance.

[jeremuck]

// pseudo-code

$prevState = "";
while( printing out the list)
{
  if($currentstate != $prevState)
  {
    echo the state
  }

  echo golf course name

  $prevState = $currentstate;
}

the idea is to keep track of the one before it. Test the current one with the previous one. If its the same, don't do anything and continue. If it is not the same, then print the state name.