How would i create a link that when clicked would change info in a database?
For example i have a user list for admin to view and i want them to be able to approve or deny (and hence delete) the user if they are not approved already.
links to enter or change information
Moderator: General Moderators
present
Code: Select all
<?
//show members
$query = "SELECT username,charname,email,approved,rank 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></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;
}
else
{
$rank = Member;
}
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>';
if ($approved == Yes)
{
echo '<td><div class="log"><a href="">Delete</a></div></td>';
}
}
echo '</table>';
?>