code problem
Posted: Wed May 21, 2003 7:02 am
at the moment approve will approve all and deny will deny all
code is:
i need it to only approve the user for the row where the link is clicked. I inserted it into the while loop as it shows the links for each user.
code is:
Code: Select all
<?php
//show members
$query = "SELECT username,charname,approved,rank,admin FROM users";
$result = mysql_query($query, $db_conn) or die('query failed');
$num_results = mysql_num_rows($result);
echo '<table cellspacing="5" cellpadding="5"><tr><td><div class="log"><u>Username</u></div></td><td><div class="log"><u>Main character name</u></div></td><td><div class="log"><u>Rank?</u></div></td><td><div class="log"><u>Approved?</u></div></td><td><div class="log"><u>Admin?</u></div></td><td><div class="log"><u>User Options</u></div></td></tr>';
while ($row = mysql_fetch_assoc($result))
{
if ($row['approved'] == 1)
{
$approved = Yes;
}
else
{
$approved = No;
}
if ($row['rank'] == 1)
{
$rank = Officer;
}
if ($row['rank'] == 2)
{
$rank = Leader;
}
elseif ($row['rank'] == 0)
{
$rank = Member;
}
if ($row['admin'] == 1)
{
$adminlvl = Yes;
}
else
{
$adminlvl = No;
}
echo '<tr><td><div class="log">'.$row[username].'</div></td>';
echo '<td><div class="log">'.$row[charname].'</div></td>';
echo '<td><div class="log">'.$rank.'</div></td>';
echo '<td><div class="log">'.$approved.'</div></td>';
echo '<td><div class="log">'.$adminlvl.'</div></td>';
if ($approved == No)
{
echo '<td><div class="log"><a href="index.php?page=members&&useradmin=approve">Approve</a></div></td>';
if ($useradmin == approve)
{
$useradmin = $_GET['useradmin'];
$query = "UPDATE users set approved = '1' where username = '$row[username]'";
$result2 = mysql_query($query, $db_conn) or die("query [$query] failed: ".mysql_error());
if (isset($result2))
{
header("Location: index.php?page=members");
}
}
}
if ($approved == Yes)
{
echo '<td><div class="log"><a href="index.php?page=members&&useradmin=deny">Deny</a></div></td>';
if ($useradmin == deny)
{
$useradmin = $_GET['useradmin'];
$query = "UPDATE users set approved = '0' where username = '$row[username]'";
$result3 = mysql_query($query, $db_conn) or die("query [$query] failed: ".mysql_error());
if (isset($result3))
{
header("Location: index.php?page=members");
}
}
}
echo '</tr>';
}
echo '</table>';
?>