[SOLVED] How To Limit A Database Field To Displaying Only One Time And Still Display All?

[phpQuestioner]

I have a data table with a field that contains the exact same text (example "some text") on several different rows. How can I display all my rows without getting duplicates of this field; I only want to display this field once. I tried to use a LIMIT, but this is not what I needed. This code is for a drop down menu.

 

Here is my current MySQL/PHP/HTML Code:

 

<form>
<select id="ajaxmenu" size="1">
<?php

mysql_connect("localhost","username","password");

mysql_select_db("myVex");

$results = mysql_query("select make from myTable order by make asc");

while($r=mysql_fetch_array($results)) {

$make=$r["make"];

echo "<option value=\"08-18-2007.php?make=Chevrolet\">$make</option>\n";

}
?>
</select>
<input type="button" onClick="ajaxcombo('ajaxmenu', 'contentarea')" value="Go">
</form>

[trq]

SELECT DISTINCT make FROM myTable ORDER BY make ASC

[phpQuestioner]

Thank You Thorpe - I Had Not Heard of "DISTINCT" before; but that did the trick.

 

Thank You for telling me about MySQL DISTINCT.