using <select> tag to edit row

notaloser

i have this code here that i want to edit a row that is selected from the database, displayed in a <select> box, then the user on the page selects the name they want to make an admin, and it should edit the line to make user_admin = 1, not 0.

here is my code:

<?PHP 

mysql_select_db("general"); 

$result = mysql_query("SELECT user_admin FROM users WHERE user_name = '".$_SESSION['user_name']."' ");

$result = mysql_fetch_array($result);

$user_admin = $result['user_admin'];

if ($user_admin==0) {
echo "<div align=center><span class=text>You are not an administrator.  If you think you are supposed to be, click Contact Webmaster.</span></td><td width=550>&nbsp;";
} else {

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



while ($a = mysql_fetch_object($result2)){



      echo '<option name=$a-> user_name>'. $a-> user_name.'</option>'; 


}
}
?>

and here is the code i want to be displayed after the option once i figure out what goes in the missing space

if(HTTP_POST_VARS['submit']) {

$result = mysql_query("EDIT user_admin FROM users WHERE user_name = 'what variable goes here for the user name selected in the <select> box?'

LordShryku

Do you assign a unique id to the users? That would make this a lot easier.

notaloser

yeah its unique

rulinus

try this...
select menu as:
<select name='new_name'>
<option value='$a-> user_name'>$a-> user_name</option>
</select>
add a hidden field for the user id.

$new_name = $_POST['select'];
mysql_query("UPDATE users SET user_name ='".$_POST['new_name']." ' WHERE user_id='$hidden_user_id' ");

i think that's a simple way to do it

LordShryku

Even easier...

echo "<select name=\"makeAdmin\">";
$result2 = mysql_query("SELECT user_name, 
                               user_id 
                          FROM users 
                         WHERE user_admin = '0'");
while($a=mysql_fetch_array($result2)) {
    echo "<option value=\"".$a['user_id']."\">".$a['user_name']."</option>";
}

This way, you just pass the id. Then your update query would just be

$sql = "UPDATE users 
           SET user_admin ='1' 
         WHERE user_id='".$_POST['makeAdmin']."'";
mysql_query($sql);