[Resolved] display results in Select Menu??

[obrienkev]

Hi all,

I want to display a list of names from a database table in a select menu.

How do I do this??

Below is my code so far:

Thanks.

$num_results = mysql_num_rows($result);
		echo '<p>Number of Tests: '.$num_results.'</p>';
		echo '
		<form id="FormName" action="" method="get" name="FormName">';

	echo   '<select name="selectName" size="1">';
	for ($i=0; $i<$num_results; $i++)
	{
		$row = mysql_fetch_array($result);
			echo '<option value=".($i+1).">'.$row['name'].'</option>
		</select>';
	}
	echo '</form>';

[obrienkev]

echo '
		<form id="FormName" action="" method="get" name="FormName">';

	echo   '<select name="selectName" size="1">';
	for ($i=0; $i<$num_results; $i++)
	{
		$row = mysql_fetch_array($result);
			echo '<option value="'.($i+1).'">'.$row['name'].'</option>';
	}
	echo '</select>';
	echo '</form>';