# Populate list with select distinct PHP MySQL

**URL:** <https://forum.kirupa.com/t/populate-list-with-select-distinct-php-mysql/31366>\
**Category:** Uncategorized\
**Created:** [September 22, 2003, 3:38am UTC](https://forum.kirupa.com/t/populate-list-with-select-distinct-php-mysql/31366 "2003-09-22T03:38:04Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![awligon](https://avatars.discourse-cdn.com/v4/letter/a/4bbf92/32.png) [@awligon](https://forum.kirupa.com/u/awligon)\
**Post date:** [September 22, 2003, 3:38am UTC](https://forum.kirupa.com/t/populate-list-with-select-distinct-php-mysql/31366/1 "2003-09-22T03:38:04Z")

</div>

```php

	  		<select name=make>
<?php
include 'db.php';
$makes = mysql_query("SELECT DISTINCT make FROM inventory;") or die(mysql_error());
$makeArray = mysql_fetch_array($makes);
foreach($makeArray as $makeOpt){
echo "<option>" . $makeOpt . "</option>";
}
?>
			</select>

```

why does this only output the first value twice in the dropList?