[PHP] Script Help

[Drompo]

<? session_start();

include 'dbConfig.php';

include("online.php");

?>

<?
$result = mysql_query("SELECT * FROM `staff`");

while($worked = mysql_fetch_array($result)) {

$selectname = $worked["username"];
}
?>
<?

if($action == "add") {

$add = mysql_query("UPDATE `staff` SET `$perms` = 1 WHERE username = '$name'");

echo "Permission: $perms has been added to user: $username";

} else {

if($username == "Choose One...") { echo "You must choose a user"; }

} 
      $query = mysql_query("SELECT * FROM `staff`");
      while($result = mysql_fetch_array($query)) {
      $selectname = $result["username"];
}
echo "<form action='add_perm.php?action=add' method='post' name='perms'>
<strong>Username:</strong><br>";
echo"<select size='1' name='name'>

<option selected>Choose a User</option>";

include('dbConfig.php');

$result = mysql_query("SELECT * FROM `staff`");

while($worked = mysql_fetch_array($result)) {

$selectname = $worked["username"];

echo "<option value='$selectname'>$selectname</option>";

}
echo "<br>
<strong>Permission:</strong><br>
<select name='perms'>
<option selected='Choose One...'>Choose a Permission</option>
<option value='Trialist'>Trialist CP</option>
<option value='DJ'>DJ CP</option>
<option value='HeadDJ'>Head DJ CP</option>
<option value='News'>News CP</option>
<option value='Users'>User Management</option>
<option value='Coding'>Coding CP</option>
<option value='Admin'>Admin CP</option>
<option value='SAdmin'>Site Admin</option>
</select>
<input type='submit' value='Add Perm'>
</form>";
?>

I made this code to Add a 1 in a table where the coloum was the value of the options. The problem i have is it only will add the permission to the Username Ash even when you select another name. Please Help.

[Skillmaster]

<? session_start();

include 'dbConfig.php';

include("online.php");

?>

<?
$result = mysql_query("SELECT * FROM `staff`");

while($worked = mysql_fetch_array($result)) {

$selectname = $worked["username"];
}
?>
<?

if($action == "add") {
$name = $_POST[name]
$add = mysql_query("UPDATE `staff` SET `$perms` = 1 WHERE username = '$name'");
echo "Permission: $perms has been added to user: $username";
} else {
if($username == "Choose One...") { echo "You must choose a user"; }

} 
      $query = mysql_query("SELECT * FROM `staff`");
      while($result = mysql_fetch_array($query)) {
      $selectname = $result["username"];
}
echo "<form action='add_perm.php?action=add' method='post' name='perms'>
<strong>Username:</strong><br>";
echo"<select size='1' name='name'>

<option selected>Choose a User</option>";

include('dbConfig.php');

$result = mysql_query("SELECT * FROM `staff`");

while($worked = mysql_fetch_array($result)) {

$selectname = $worked["username"];

echo "<option value='$selectname'>$selectname</option>";

}
echo "<br>
<strong>Permission:</strong><br>
<select name='perms'>
<option selected='Choose One...'>Choose a Permission</option>
<option value='Trialist'>Trialist CP</option>
<option value='DJ'>DJ CP</option>
<option value='HeadDJ'>Head DJ CP</option>
<option value='News'>News CP</option>
<option value='Users'>User Management</option>
<option value='Coding'>Coding CP</option>
<option value='Admin'>Admin CP</option>
<option value='SAdmin'>Site Admin</option>
</select>
<input type='submit' value='Add Perm'>
</form>";
?>

Try That?

Forgot the $POST variable for the username.

[PinkFM]

Basically when he tries to add a permission (admin or something like that) it will only add to the account Ash and no other accounts even when there name is selected

[Drompo]

Thanks. It works now but i recoded it with $post and classes

[phpme]

errr... i would help but i can only do dat to my Dj Panels like my panel called pp to release sooN!