[RESOLVED] Dynamically populating a drop-down box

[jamesjohnson88]

I would like to populate a drop down box with entires from a column in a sql table.

How do I go about doing this?

[jamesjohnson88]

Here is what I have so far -

<!-- SQL Populated Drop Down -->
			<form method="post" action="showleague.php">
			<?php
		error_reporting(E_ALL);

	//Connect & Select.
	$con = mysql_connect("localhost","jsoftwa1","P8RU7M!A");
	if (!$con)
	  {
	  	die('Could not connect: ' . mysql_error());
	  }

	mysql_select_db("jsoftwa1_LeagueSQL", $con);

	$result = mysql_query("SELECT LeagueName FROM League_Index");

	while ($data=mysql_fetch_assoc($result)){

	?>
			<span class="search">Select a league:</span>&nbsp;&nbsp; 
			<select name="leagueName">
			<option value ="<?php echo $data['LeagueName'] ?>" ></option>
	<?php } ?>
			</select>&nbsp;&nbsp;&nbsp;<input type="submit" value="view" class="button" />
		</form>

The page works ok but nothing shows up in the dropdown box.

EDIT: Forgot to add the code in between the option braces too.