how to put more rows of a query into one drop down box?

[viktor1983]

hello,

i have the following sql query:

"SELECT DISTINCT reference1,reference2,reference3 FROM partners;"

i can put reference1, reference2,reference3 into different drop down boxes, but how can i put them into one box, without having repeating values?

thanks in advance,

viktor

[bastien]

while $rows=mysql_fetch_array($result)){

$ref1=$rows['reference1'];
$ref2=$rows['reference2'];
$ref3=$rows['refernece3'];
$id   =$rows['rowid'];

echo "<option value=\"$id\">$ref1::$ref2::$ref3";

}

hth