[SOLVED] loop de loop

[beansandsausages]

hey all, I have a bit of doe thats working but now how i expected, 

 

$sql = "SELECT * FROM `members` ";
		$result = mysql_query($sql);
		while ($test = mysql_fetch_assoc($result)) {


		$username = array("$test[username]"); 

		foreach ( $username as $element ) { 
   
    			echo "<select><option>$element</option></select>"; 

		} 			

its gets all the records, but instead of populationg one box its creats a new one for every box,

 

i bet its a simple fix or solution but just cant see were iv gone wrong

[Daniel0]

echo '<select>';
foreach ($username as $element) {
    echo "<option>{$element}</option>";
}
echo '</select>';

[beansandsausages]

thanx for the reply but hasnt changed, still putting each record in its own drop down box rather that just one single one,

 

$sql = "SELECT * FROM `members` ";
		$result = mysql_query($sql);
		while ($test = mysql_fetch_assoc($result)) {

		$username = array($test['username']);
		echo "<select>";
		foreach ($username as $element) {
    			echo "<option>{$element}</option>";
		}
		echo "</select>";




		}

[BlueSkyIS]

$sql = "SELECT * FROM `members` ";
$result = mysql_query($sql) or die(mysql_error());
echo "<select>";
while ($test = mysql_fetch_assoc($result)) {
     $username = $test['username'];
      echo "<option>$username</option>";
}
echo "</select>";