To Robothy:
Thank you for finding that missing curly brace. I had been looking for a long time, and I guess I just missed it in Notepad ++.
However, I now have a new problem. When I click "Yes" to delete the user, the user never gets deleted. I ran the exact same query in the regular MySQL database and it worked. Something else I'm missing?
<?php
session_start();
include('header.php');
if((isset($_GET['id'])) && (is_numeric($_GET['id']))) {
$id = $_GET['id'];
} elseif
(isset($_POST['id'])){
$id = $_POST['id'];
} else {
header("Refresh: 60;URL=current_users.php");
echo "This page has been accessed in error. Redirecting you to the previous page".mysql_error();
}
require_once('mysql_connect.php');
if(isset($_POST['submitted'])){
if($_POST['sure'] == 'Yes') {
$query = "delete from movie_users where movie_users_id = $id";
$result = @mysql_query($query);
header("Refresh: 3;URL=current_users.php");
echo "User deleted successfully";
}
$query = "select concat(last_name, ',' first_name) from movie_users where movie_users_id = $id";
$result = @mysql_query($query);
if (mysql_num_rows($result) == 1) {
$row = mysql_fetch_array($result, MYSQL_NUM);
}
}
?>
<body>
<form action="delete_user.php" method ="post">
<div id="main">
<p>Are you sure you want to delete this user?<br />
<input type = "radio" name = "sure" value = "Yes" /> Yes
<input type = "radio" name = "sure" value = "No" /> No</p>
<p><input type = "submit" name = "submit" value = "Submit" /> </p>
<input type = "hidden" name = "submitted" value = "TRUE" />
<input type = "hidden" name = "id" value = "' . $id . '" />
</form>
</body>
</div>
mysql_close();
<?php
include('footer.php');
?>