problem in deleting a row of database from php page

[lindaonline15]

hi all
Im trying to make user account management page for admin.
it should delete the row, but when I click delete, the page refreshes with no change and does not delete the row.
anyone know whats the problem?

here's the php code

<?php
include_once "connection.php";

?>

<h2>Users</h2>
<table class="results-table" border = "1">
<tr>
<th scope="col"><strong>Name</strong></th>
<th scope="col"><strong>E-Mail</strong></th>
<th scope="col"><strong>Username</strong></th>
<th scope="col"><strong>Password</strong></td>
<th scope="col"><strong>Access Level</strong></th>
</tr>

<?php

$query = "SELECT name, email, username, Access_lvl FROM users ORDER BY Access_lvl, name";
$result = mysql_query($query) or die (mysql_error());
$num=mysql_num_rows($result);
?>

<?php

if(!isset($cmd))
{
while ($row = mysql_fetch_assoc( $result ))
{
$n = $row['name'];
$e = $row['email'];
$un = $row['username'];
$p = $row['password'];
$al = $row['Access_lvl'];

print("<tr>");
print("<td>$n</td>");
print("<td>$e</td>");
print("<td>$un</td>");
print("<td>$p</td>");
print("<td>$al</td>");

echo "<td><a href='users-show3.php?cmd=delete&username=$un'>Delete</a></td>";

}

}

?>

</table>

<?
if($_GET['cmd']=="delete")
{
$sql = "DELETE FROM users WHERE username=$un";
$result = mysql_query($sql);
echo "Row deleted!";
}
?>

<br /><strong>
<?php print("$num") ?> User(s).</strong> <br/> <br />

<?php
mysql_close();
?>

[henry0]

How do you define $un?
if you echo"UN: $un<p>"; I guess you will get nothing

you need adding something like a dropdown with all usernames listed or where un = any subquery,
then select that user and then pass its value

unless you are not showing us how you select a user?

[dreamcatcher]

The variable you should be accessing is $_GET['username']. So, before:

$sql = "DELETE FROM users WHERE username=$un";

add:

$un = $_GET['username'];

dc