delete query problem

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

PHP:

 

This comes because $page['id'] is empty, because it seems not to be an array:

Should be

if ($page == get_page_by_id($id)) {
        
        $query = "DELETE FROM pages WHERE id = {$id} LIMIT 1";

PHP:

Regards

 

thanks alot sir it works
you help alot

 

You are welcome, glad it helped