<?php
$conn = mysql_connect("localhost","root","123");/*数据库*/
mysql_query("set names GB2312");
$db = mysql_select_db("miaolaor");
$id = $_GET['id'];
$sql="delete 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.rid";
/*删除left_word留言内容同时删除write_back_left_word回复内容*/
//$sql = "delete from left_word where id='".$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 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.rid";
/*删除left_word留言内容同时删除write_back_left_word回复内容*/
//$sql = "delete from left_word where id='".$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;?>
WHERE left_word.id = '".$id."' and left_word.id = write_back_left_word.rid";WHERE子句里and改成or就行了