delete query problem

[azeem123456]

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/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);
?>

[mapleleaf]

Where is this set? $page['id']

maybe it is an array and it should be $page[0] depending on where in the array it is.