Filling a <select> with info from a database

1

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.

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:

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