同数据库内 留言内容在一个表,回复内容在一个表,我想删除留言内容的同时把另一张表内的回复内容同时删除了,请问怎么连接?删除单表内容可以,连接语句怎么弄?<?php
$conn = mysql_connect("localhost","root","123");/*数据库*/
mysql_query("set names GB2312");
$db = mysql_select_db("miaolaor");
$id = $_GET['id'];
$sql = "delete from left_word where id='".$id."'";
//$sql="INSERT INTO left_word,write_back_left_word FROM left_word,write_back_left_word
//WHERE left_word.id = '".$id."' and left_word.id = write_back_left_word.id";
mysql_query($sql);
$ = mysql_affected_rows();//返回影响行数
if($>0)
{
echo "<script>
alert('删除成功!返回留言。');
location.href='left_word_binding.php';
</script>";
}else
{
echo "<script>
alert('删除失败!返回留言。');
location.href='left_word_binding.php';
</script>";
}
mysql_close();
echo $sql;?>
$conn = mysql_connect("localhost","root","123");/*数据库*/
mysql_query("set names GB2312");
$db = mysql_select_db("miaolaor");
$id = $_GET['id'];
$sql = "delete from left_word where id='".$id."'";
//$sql="INSERT INTO left_word,write_back_left_word FROM left_word,write_back_left_word
//WHERE left_word.id = '".$id."' and left_word.id = write_back_left_word.id";
mysql_query($sql);
$ = mysql_affected_rows();//返回影响行数
if($>0)
{
echo "<script>
alert('删除成功!返回留言。');
location.href='left_word_binding.php';
</script>";
}else
{
echo "<script>
alert('删除失败!返回留言。');
location.href='left_word_binding.php';
</script>";
}
mysql_close();
echo $sql;?>
left_word 留言表
write_back_left_word 回复表
只要【回复表的留言ID = 留言表的ID】即可
$sql1 = "DELETE FROM left_word WHERE id =".$id;
$sql2 = "DELETE FROM write_back_left_word WHERE wordId =".$id;
上面wordId是留言表ID的意思
MYSQL 不支持事务操作,建议去了解MYSQL的触发器,主要是防止多表分别删除的时候若其中一个表删除失败,其他全部停止删除的效果。
PHP mysql删除操作:
myqsl_query($sql1, $conn);
mysql_query($sql2, $conn);
$conn = mysql_connect("localhost","root","123");/*数据库*/
mysql_query("set names GB2312");
$db = mysql_select_db("miaolaor");
$id = $_GET['id'];
$sql = "delete from left_word where id='".$id."'";
//$sql="INSERT INTO left_word,write_back_left_word FROM left_word,write_back_left_word
//WHERE left_word.id = '".$id."' and left_word.id = write_back_left_word.id";
mysql_query($sql);
$ = mysql_affected_rows();//返回影响行数// 刪另一個表
$sql2 = "delete from left_word2 where id='".$id."'";
mysql_query($sql2);
$2 = mysql_affected_rows();//返回影响行数if($>0)
{
echo "<script>
alert('删除成功!返回留言。');
location.href='left_word_binding.php';
</script>";
}else
{
echo "<script>
alert('删除失败!返回留言。');
location.href='left_word_binding.php';
</script>";
}
mysql_close();echo $sql;
echo $sql2;?>