Dropdown dilema

[SFDonovan]

I have tried to get this box to pull usernames out of my table with no luck at all.

// create the SQL statement
 $user = "SELECT name, uniqueid, password FROM milpacs_members";
 if (!$user) {
	 exit("<p>Unable to obtain usernames from database.</p>");
 }
echo "<p><label for=\"name\">Username: </label>";
echo "<SELECT NAME=\"name\" size=\"1\">"; 
echo "<OPTION SELECTED VALUE=\"\">--- Select User ---</OPTION>";
while ($user = mysql_fetch_array($user)) 
{ 
$uid = $user["uniqueid"]; 
$name = $user["name"];  

echo "<OPTION VALUE='$uid'>$name</OPTION>";
}  

echo "</SELECT>";

[bodzan]

...I would use a different name for the variable that the result is stored, like $sql or something else, because it might be confusing the code...

[Roger_Ramjet]

It might help if you actually ran the query (with mysql_query) before trying to access the results. And yes, bodzan is right, you can't just keep using the same variable name willy-nilly.