Update problem, very odd.

[cdbsi]

<?php

include("db.inc");

$db=mysql_connect("localhost", $dbuser, $dbpassword) or die("could not connect");
mysql_select_db($userdb);

if ($disableuser) {
	$id=$rowid;
	mysql_query("UPDATE users SET disabled='1' WHERE id='$rowid'",$db);
	header("Location: users.php");
	exit;
}
if ($enableuser) {
	$id=$rowid;
	mysql_query("UPDATE users SET disabled='0' WHERE id='$rowid'",$db);
	header("Location: users.php");
	exit;
}

// Fill group list
$result=mysql_query("SELECT * FROM groups",$db);
while($row=mysql_fetch_array($result)){
	$group[$row[name]]=$row[desc];
}

$result=mysql_query("SELECT * FROM users WHERE id=$rowid",$db);
$row=mysql_fetch_array($result);

?>
<title>Website Administration: Disable User</title>

Username: <?= $row[uname] ?><br>
First Name: <?= $row[uname] ?><br>
Last Name: <?= $row[uname] ?><br>
Last Login: <?= $row[lastlogin] ?><br>

<form method=post action=<?= $PHP_SELF ?>>
<input type=hidden name=rowid value=<?= $rowid ?>>
<?

if ($row[disabled] == "0") {
	echo "\n<input type=hidden name=disableuser value=1>\n<input type=button value='Disable Account'> WARNING: This will disable the user's account.";
}
if ($row[disabled] == "1") {
	echo "\n<input type=hidden name=enableuser value=1>\n<input type=button value='Enable Account'> This account is disabled.";
}

?>
</form>

I don't understand why it won't update the database. This page is for disabling user accounts.

[nnichols]

Explain briefly what does or doesn't happen

[cdbsi]

I just doesn't update the table.

It doesn't even return an error. 🙁

[nnichols]

Try adding a little bit of debug code to your queries so you can find out what is going on -

if ($disableuser) {
	$id=$rowid;
	$sql = "UPDATE users SET disabled='1' WHERE id='$rowid'";
	$res = mysql_query($sql,$db);
	if (!$res) {
    		echo 'Disable query: ' . $sql . '<br>Error: ' . mysql_error();
    		exit;
    		}
	header("Location: users.php");
	exit;
}
if ($enableuser) {
	$id=$rowid;
	$sql = "UPDATE users SET disabled='0' WHERE id='$rowid'";
	$res = mysql_query($sql,$db);
	if (!$res) {
    		echo 'Enable query: ' . $sql . '<br>Error: ' . mysql_error();
    		exit;
    		}
	header("Location: users.php");
	exit;
}

If it doesn't update and doesn't return the errors it means that the script doesn't receive your $enableuser/$disableuser variables.

[cdbsi]

still doesn't update it, and without any errors. 😕

it also receives the $enableuser/$disableuser variables.

[xblue]

check this line:

<input type=hidden name=rowid value=<?= $rowid ?>>

I can't see where $rowid is coming from. If it was from the db query, it should be something like $row['id'].

if $rowid isn't set, your queries

"UPDATE users SET disabled='1' WHERE id='$rowid'";
"UPDATE users SET disabled='0' WHERE id='$rowid'";

would execute without a problem. They'd try to update records where id is empty, and probably update no records, but wouldn't return an error.