displaying query result in select

[notaloser]

im making an edit admin page on my website, and i ran the code

$result2 = mysql_query("SELECT user_admin FROM users WHERE user_admin = '0' ");

user_admin = 0 means the user is not an admin, user_admin = 1 means they are an admin.

i want to display all the users that are not admins in a drop down box, so an admin on this page can select the user they want to make an admin and press ok, then $result3 will edit the row to make user_admin = 1..

then the opposite farther down the page for deleting an admin, with user_admin = 1 as the $result4 and when you select a user $result5 will edit the line to make user_admin = 0.. but i want you to have to enter a password to delete an admin...

anyone?

[LordShryku]

Where are you stuck? What's the problem? Seems you already have the query, now just loop through the results as options.

[notaloser]

im stuck with the part about displaying $result2 into a select box, lol... cant find any good posts anywhere

[LordShryku]

Seems fairly self explanitory, but ok...

<?php
$result2 = mysql_query("SELECT user 
                          FROM users 
                         WHERE user_admin = '0'");
if(mysql_num_rows($result2) > 0) {
?>
<select>
<?php
   while($row=mysql_fetch_array($result2)) {
?>
<option><?php echo $row['user']?></option>
<?php
   }
}
?>

[notaloser]

that doesnt seem to work, the select box wont appear

[sunshine66]

You need to close the select box:

<?php 
$result2 = mysql_query("SELECT user 
                          FROM users 
                         WHERE user_admin = '0'"); 
if(mysql_num_rows($result2) > 0) { 
?> 
<select> 
<?php 
   while($row=mysql_fetch_array($result2)) { 
?> 
<option><?php echo $row['user']?></option> 
<?php 
   } 
} 
?> 
</select>