Only one of each

[Buschmaster]

So I have a bunch of stuff in a database that I'm drawing with PHP into a form. Here is my code

$result2 = mysql_query("SELECT make FROM $type");
echo "Make: ";
while ($row = mysql_fetch_array($result2, MYSQL_ASSOC)) {
printf("<option value=\"%s\">%s ", $row["make"], $row["make"]);
}
echo '</select><input type="submit" value="Next Step"></form>';

Which works great, EXCEPT the data it is returning contains things like
Dodge
Dodge
Ford
Dodge
Ford
Chevy
etc.

So it's returning all these and I only want one of each of them... Of course, I could just manually enter every make of car ever, but that's no fun 😛

[drew010]

you can use
SELECT DISTINCT make FROM $type
instead of
SELECT make FROM $type
and it will only return 1 of each type.

[Buschmaster]

Oh great! Thanks!