rendered paste body case delete_user: echo "Select a user:<br /><br />"; echo "<form action='index.php?page=delete_user2' method='post'><select name='usr'>"; $con = db_connect(); $result = mysql_query("SELECT UserName FROM users"); while($row = mysql_fetch_array($result)) { echo "<option value='{$row['UserName']}'>" . $row['UserName'] . "</option>"; } echo "</select><br /><br />"; echo "<input type='submit' name='submit' value='Delete' /></form>"; mysql_close($con); break; case delete_user2: $usr = $_REQUEST['usr']; $con = db_connect(); $result = mysql_query("DELETE FROM users WHERE UserName = '$usr'") or die(mysql_error()); if (!$con) { die('Could not connect: ' . mysql_error()); } if(mysql_num_rows($result) >= 1) { echo 'User Deleted successfully<br />'; } else { echo 'Unable to Delete User<br />'.$result.'<br />' . $con->error; } mysql_close($con); break;