help in duplicate listing

[snake310]

i have a code:

$inter="SELECT model FROM $get2";
$id_rez=mysql_query($inter);
$row=mysql_num_rows($id_rez);
while($rand=mysql_fetch_row($id_rez))
for($i=0;$i<$row;$i++)
echo "<option>".$rand[$i]."</option>";
So this works fine , but i dont know how to evade to list every item just once , like if i have 3 of the same model i would like to show only 1

pls help i tried a lot of stuff it didnd`t work

[mkosmosports]

So are you trying to list the "model" item only once (no duplicates)?

I assume you are so change the $inter variable to read:

$inter="SELECT DISTINCT model FROM $get2";

[ted_chou12]

Since what you fetch from mysql is an array anyways, try this:
<?php
// Assign values to array
$one = array(1,2,3,4,3,6,1,3,2);

// Create an array of unique values from $one
$two = array_unique($one);

// Output as proof
echo "<pre>\n";
print_r($two);
echo "</pre>\n";
?>

[snake310]

thx that is what i needed but there is still one thing it leaves blank fields... any ide what to do?

[ted_chou12]

blank fields? ???, sorry, i dont understand...

[snake310]

what i am listing there is a select list menu and now it goes like

model1
(blank)
(blank)
model2
(blank)
model3

and blank meant that it`s nothing there but it is selectible

[snake310]

btw Problem solved thx for the help guys

[HuggieBear]

This is the best way to do what you're after...

[code]<?php
$inter = "SELECT DISTINCT model FROM $get2";
$id_rez = mysql_query($inter);
while ($rand = mysql_fetch_array($id_rez, MYSQL_ASSOC)){
  echo "<option>".$rand['model']."</option>";
}
?>[/code]

Regards
Huggie