向数据库发送查询时出现问题

Question

当我点击一个按钮时，我想从我的数据库中删除3个字段：fk_id_band，id_band和band。

但是我在将mysql查询从PHP文件发送到数据库时遇到了问题。

我有以下PHP代码：

<?php
    session_start();
    include('database.php');

    $id = $_SESSION['id'];

    $select = "SELECT *
    FROM users
    WHERE id_user = ".$id."";

    $result = mysql_query($select);

    $line = mysql_fetch_assoc($result);

    $idband = $line["fk_id_band"];


    $sqldelete = "DELETE bands
    FROM bands
    WHERE id_band = ".$idband."";

    echo $sqldelete;

    mysql_query($sqldelete);                                                                                                                                                      
?>

当我在phpmyadmin中插入查询时，它可以工作。(DELETE bands FROM bands WHERE id_band = 1)

但是，当我使用mysql_query($sqldelete)时，它不会像我认为的那样自动更新数据库。

这是怎么回事？

Answer 1

delete语句中存在语法错误

$id = $_SESSION['id'];

$select = "select * from users WHERE ID = $id";
$result = mysql_query($select); 
$line = mysql_fetch_assoc($result); 

 $idband = $line["fk_id_band"];
 $sqldelete = "DELETE bands
 FROM bands
WHERE id_band = ".$idband;
echo $sqldelete;

mysql_query($sqldelete);