php/mysql drop down menu

[Mr_Chew]

I have a database with a login table. I am trying to populate a dropdown menu that lists all the usernames from the username field in the login table for a private messaging system that I have.

i have tried an attempt at this but know it's completely wrong..

<?php

include './template/connect.php';

$query = "SELECT username FROM login";
mysql_query($query);

$query = mysql_query('SELECT * FROM login');
	if(mysql_error()) 
	{
		print(mysql_error());
	}

while($row = mysql_fetch_array($query)) 
echo'<select name="select">';		
	{
			echo'<option value="'.$row[username].'">'.$row[username].'"</option>';
	}	
echo'</select>';

?>

any help to list all the usernames in a dropdown would be great. thank you.

[sosothree]

I think you have some issues near your while statement.

Try this:

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

[bradmasterx]

could you give us the error for to receive the error in the option list
"right-click"->"view source"->"ctrl+f"->"<option value"->"Read error"