Not all rows are being selected.

[blackairplane]

I'm having this issue where I'm populating a <multiple> HTML field with around 500 city names that are stored in a MySQL table, but when the page loads, it is only showing a portion of the rows (city names) with no obvious reason for why it's omitting some.

 

<select multiple="multiple" size="10">			
		<?php while($row = mysql_fetch_array($result))
			  {
			echo "<option value='".$row['name'].">";
			echo $row['name'];
			echo "</option>";
			  }
?>
		</select>

[trq]

Your missing a closing ' in your html.

 

	
echo "<option value='".$row['name']."'>";

[blackairplane]

Wow. It's the little foxes that spoil the vine. Thanks for the help!