php - 1 个变量中的 2 个 Mysql 查询，有帮助吗？

Question

$qry1 = "DELETE FROM
    si_topics
WHERE
    topic_id = '". $_GET['topic'] ."'
DELETE FROM 
    si_posts
WHERE
    topic_id = '". $_GET['topic'] ."'";

$mysqlqry1 = mysql_query($qry1);
if($mysqlqry1){
    echo 'Topic deleted from database!';
} else {
    echo 'Mysql query failed!';
}

这给出了消息Mysql查询失败!，为什么？

问候

Answer 1

两个删除语句之间缺少分号。

此外，mysql_query 不支持多个查询。

来自the documentation :

mysql_query() sends a unique query (multiple queries are not supported) to the currently active database on the server that's associated with the specified link_identifier.`