[RESOLVED] Using arrays and loops for a drop down

[LuiePL]

I'm looking to make a "Modify User" page, and I'm thinking I'm going to need to dynamically create the drop down box. So what I'm thinking as the basics are:

-Run a SELECT query to get the user names
-Create a variable that is for the username
-Create a loop that runs until it gets to the end of the records
-Use an array of some sort to pick the user out of the records and add it to the drop down box

$query = "SELECT * FROM Login"; 
$sql = mysql_query($query);
$option = ""

<select size='1' name='user'>
while (not the end of records)
     {
          $option = $option.'<option value="$name">$name</option>';
          go to next record
     }
</select>

or something along those lines.

Thanks!

EDIT - Changed the option concatination...

[Installer]

Yes, something along those lines should work.

[LuiePL]

Figured it out:

$dbh=mysql_connect ("localhost", "user", "password");
mysql_select_db ("database");

$query = "SELECT * FROM table ORDER BY 'name' ASC";
$sql = mysql_query($query);

echo "<select size='1' name='user'>";

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

When I get home I'll test it on updating the password, but it looks like it should be good to go now.