# Filling a \<select\> with info from a database

**URL:** <https://forum.kirupa.com/t/filling-a-select-with-info-from-a-database/32678>\
**Category:** Uncategorized\
**Created:** [October 9, 2003, 8:01pm UTC](https://forum.kirupa.com/t/filling-a-select-with-info-from-a-database/32678 "2003-10-09T20:01:57Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![jeremy](https://avatars.discourse-cdn.com/v4/letter/j/82dd89/32.png) [@jeremy](https://forum.kirupa.com/u/jeremy)\
**Post date:** [October 9, 2003, 8:01pm UTC](https://forum.kirupa.com/t/filling-a-select-with-info-from-a-database/32678/1 "2003-10-09T20:01:57Z")

</div>

I am trying to fill a select pull down, with info from a database.  
my table is called oil  
my field is called supplier

it will go into a function that looks sorta like this.

```php
function write_form() {
	print "<form method=\"POST\">
";
	print "<input type=\"text\" name=\"name\">";
    print "name<p>
";
    print "<select name=\"supplier\">";
//------loop through table field, print <option> for each-------

	print "</select>";

```

here is my mysql query:

```php
$query_supplier = "SELECT * FROM oil";
$connect_query = mysql_query($query_supplier, $link) or die(mysql_error());
$a_row = mysql_fetch_assoc($connect_query);

```