Drompo
20-03-2007, 06:35 PM
<? 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.
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.