<select name="make"> <?php $query = mysql_query("SELECT DISTINCT Make FROM your_table"); $options = ''; while ($row = mysql_fetch_array($query)) { $options .= '<option value="'.stripslashes($row['Make']).'">'.stripslashes($row['Make']).'</option>'; } echo $options; ?> </select>