php mysql删除失败_PHP不会从MySQL中删除

出于某种原因,

JavaScript / PHP不会从MySQL中删除我的数据！这是问题的破败.

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

include("login.php");

//connection to the database

$dbhandle = mysql_connect($hostname, $username, $password)

or die("

Unable to connect to MySQL, please contact support at support@michalkopanski.com

");

//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)) {

?>

http://www.youtube.com/watch?v=<?php echo $row{'url'}; ?> delete

//close the connection

mysql_close($dbhandle);

?>

删除按钮有一个javascript：javascript：确认(),所以一旦你点击删除,它就会运行：

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

include ("login.php");

mysql_connect($hostname, $username, $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.");

?>

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

谢谢！