delete user

[sonu]

here is my user page code
<?php

require '../global.php';

if ( inPOST() )
{
mysql_query("UPDATE users SET userBanned = '".input('status')."' WHERE userID = '".input('id')."' LIMIT 1");
}

?>
<h2>Administration Panel</h2>
<ul>
<li><a href="site-status.php">Site Status</a></li>
<li><a href="users.php">Users</a></li>
<li><a href="mail.php">Mail</a></li>
</ul>

<h3>Users</h3>
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td><div align="center"><strong>User</strong></div></td>
<td><div align="center"><strong>Join IP </strong></div></td>
<td><div align="center"><strong>Last IP </strong></div></td>
<td><div align="center"><strong>Status</strong></div></td>
</tr>
<tr>
<?php
$fetch = mysql_query("SELECT * FROM users LEFT JOIN user_extra ON ( userID = userExtraID ) ORDER BY userID ASC" );
while ( $row = mysql_fetch_assoc ( $fetch ) )
{
?>
<td align="center">

<div><a href="../user.php?id=<?=$row['userID'];?>"><?=$row['userName'];?></a></div>
<?
if ( file_exists ( '../photos/' . $row['userPhoto'] ) && strlen ( $row['userPhoto'] ) >= 5 )
{
?>
<div><a href="../user.php?id=<?=$row['userID'];?>"><img src="../photos/<?=$row['userPhoto'];?>" alt="" border="0" /></a></div>
<?
}
?>
</td>
<td align="center"><?=$row['userJoinIP'];?></td>
<td align="center"><?=$row['userLastIP'];?></td>
<td align="center">
<form action="users.php" method="post">
<input type="hidden" name="id" value="<?=$row['userID'];?>" />
<?php
if ( $row['userBanned'] == 'yes' )
{
?>
<input type="hidden" name="status" value="no" />
<input type="submit" value=" Un-Ban " />
<?
}
else
{
?>
<input type="hidden" name="status" value="yes" />
<input type="submit" value=" Ban " />
<?
}
?>
</form>
</td>
</tr>
<?
}
?>
</table>

i want to add button " Delete " for deleting user from database.

[blackpepper]

DELETE FROM table_name
WHERE column_name = some_value

[sonu]

sorry can not understand
i want to select user from list for deleteing so wht is value for it?
how i put delete butten?

[sonu]

can u past correct full code?