echo "<form enctype='multipart/form-data' method='post' action='combined_sales1.php'>";
echo "<select name='team' style='width: 300px'>\n";

$query = "SELECT * FROM teams WHERE team_view='1'";
$result=mysql_query($query) or die(mysql_error());
while($row = mysql_fetch_array($result))
{
$var1 = $row['team_id'];
$var2 = $row['team_name'];

echo "<option value='";
echo $var1;
echo "'>";
echo $var2;
echo "</option>\n";
}

echo "</select>\n";
echo "<input style='width: 200px' name='submit' type='submit' value='Submit'></form>";