[Resolved] how can I make this loop ignore duplicate tables

[airric]

basically I'm trying to populate a search category with data in the db. It pulls up everything in the field, but I can't seem to figure out how to get it not to pull duplicate names from the db field.

Maybe a while loop just can't do that??
Here is what I have.

$query= "SELECT " . $field[2][4] . " FROM " . $db . " order by " . $field [2][4];
$result = @mysql_db_query($mysql_db, $query) or die ("Invalid query (result)");

while ($row = @mysql_fetch_array($result))
{
$link_field_2 = ($row[ $field[2][4] ]);

{
echo "<a href=\"index.php?search_type=brand&search=$link_field_2&dvd_search_results=0&dvd_max_results=\"20\" class=\"style1\">$link_field_2</a><br/>";

} }

thanx, Airric

[paulnaj]

Using DISTINCT in the sql should do it ...

SELECT DISTINCT " . $field[2][4] . " FROM " . $db . " order by " . $field [2][4]

Paul.

[airric]

Thanx Paul that did it.