:(delete query problem

[Azeem12]

hi i am making content management system and i m having issue in deletion of page
when i press delete then it gives me error

Page deletion failed.
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'LIMIT 1' at line 1
Return to Main Site ...kindly help me please
my code is

<?php require_once("includes/session.php"); ?>
<?php require_once("includes/connection.php"); ?>
<?php require_once("includes/functions.php"); ?>

<?php
	// make sure the subject id sent is an integer
	if (intval($_GET['page']) == 0) {
		redirect_to('content.php');
	}

$id = mysql_prep($_GET['page']);

// the page's subject_id for the redirect
if ($page = get_page_by_id($id)) {

	$query = "DELETE FROM pages WHERE id = {$page['id']} LIMIT 1";
	$result = mysql_query ($query);
	if (mysql_affected_rows() == 1) {
		// Successfully deleted
		redirect_to("edit_subject.php?subj={$page['subject_id']}");
	} else {
		// Deletion failed
		echo "<p>Page deletion failed.</p>";
		echo "<p>" . mysql_error() . "</p>";
		echo "<a href=\"content.php\">Return to Main Site</a>";
	}
} else {
	// page didn't exist, deletion was not attempted
	redirect_to('content.php');
}
?>
<?php 

mysql_close($db);
?>

[bradgrafelman]

Sounds like $page['id'] is NULL (or otherwise not an integer). You can verify this by echo'ing out $query to visually examine the SQL query that's failing.

[Ashley_Sheridan]

I can't see where $page['id'] is being created, so like bradgrafelman said, it's most likely empty. If you get an error about the syntax of your sql, it's best to output the query to see exactly what you're attempting to get mysql to run.

I'm assuming the $page array is being created in one of your include files. Do you have an excerpt from that that might show where the problem lies?