Delete User Ch. 13

djlfreak · June 3rd, 2010, 09:57 AM

Hi All,
I want to add a Delete User button to Modify Account in cms_user_account in Chapter 13.
I inserted the following case in cms_transact_user but it didn't work. I really need this to work as I am using this as part of my assignment due tomorrow.
Please someone reply, I would be very grateful indeed.

PHP Code:


			
    case 'Delete User':

        session_start();

        if (isset($_POST['delete user']) && $user_id='') {

        $sql = 'DELETE FROM site_users WHERE user_id = ' . $user_id;

        mysql_query($sql, $db)

        or die('Could not update user account; ' . mysql_error());

        }

        redirect('cms_admin.php');

        break;

The button for delete in cms_user_account.

PHP Code:


			
<?php

if ($_SESSION['access_level'] > 2) {

    echo '<tr>';

    echo '<td> </td>';

    echo '<td> <input type="submit" name="action" value="Delete User"/> ';

    echo '</td>';

}

?>

Thanks in advance for any help with this.