PHP不会从MySQL中删除

我有一个数组,以一种很好的格式显示我所有的MySQL条目,并带有一个按钮,可以单独删除每个条目的条目.它看起来像这样：

<?php

            include("login.php");

        //connection to the database
        $dbhandle = mysql_connect($hostname,$username,$password)
         or die("<br/><h1>Unable to connect to MySQL,please contact support at support@michalkopanski.com</h1>");

        //select a database to work with
        $selected = mysql_select_db($dbname,$dbhandle)
          or die("Could not select database.");

        //execute the SQL query and return records
        if (!$result = mysql_query("SELECT `id`,`url` FROM `videos`"))
        echo 'mysql error: '.mysql_error();

        //fetch tha data from the database
        while ($row = mysql_fetch_array($result)) {
           ?>

       <div class="video"><a class="<?php echo $row{'id'}; ?>" href="http://www.youtube.com/watch?v=<?php echo $row{'url'}; ?>">http://www.youtube.com/watch?v=<?php echo $row{'url'}; ?></a><a class="del" href="javascript:confirmation(<? echo $row['id']; ?>)">delete</a></div>

<?php }

//close the connection
mysql_close($dbhandle);
?>

删除按钮有一个javascript：javascript：确认(<？echo $row ['id'];？>),所以一旦你点击删除,它就会运行：

<script type="text/javascript">
<!--
function confirmation(ID) {
    var answer = confirm("Are you sure you want to delete this video?")
    if (answer){
        alert("Entry Deleted")
        window.location = "delete.php?id="+ID;
    }
    else{
        alert("No action taken")
    }
}
//-->
</script>

从理论上讲,JavaScript应该将’ID’传递给页面delete.php.该页面看起来像这样(我认为这就是问题所在)：

<?php

include ("login.php");

mysql_connect($hostname,$password)
 or die("Unable to connect to MySQL");

mysql_select_db ($dbname)
or die("Unable to connect to database");

mysql_query("DELETE FROM `videos` WHERE `videos`.`id` ='.$id.'");
echo ("Video has been deleted.");
?>

如果有人可能知道答案,我会非常感激.我也接受了建议(对于那些不确定的人).

谢谢！