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);