Avoiding Repeats

[Doc Thirst]

Quick question. I'm a table, which might have the same name repeated in several rows, to populate a select list:

$recordset = mssql_query ("select * from purchaseorder order by reqname", $handle);
while($arr = mssql_fetch_row($recordset))
{
     $name = $arr[1];
     echo "<option>$name";
}

As you can see, if there is more then one entry with the same name the select list will list the name several times.

I can't seem to think of a way to avoid this, but I know there must be a way.

For instance:

$recordset = mssql_query ("select * from purchaseorder order by reqname", $handle);
while($arr = mssql_fetch_row($recordset))
{
     if($name == '%$totallist%')
     {
          $name = $arr[1];
          echo "<option>$name";
     }
     $totalnames = "$totalnames $name";
}

Although I know my if statment is not valid, how do you pros do it?

[NogDog]

$recordset = mssql_query ("SELECT DISTINCT reqname FROM purchaseorder ORDER BY reqname", $handle);
while($arr = mssql_fetch_row($recordset))
{
     echo "<option>".$arr[0]."</option>\n";
} 

[Doc Thirst]

Ugg, soooo easy, I'm a tool. Thanks once again NogDog