作者chrismaggie (中仔)
看板Database
標題Re: [SQL ] 請問這個mysql語法哪邊出了錯誤呢
時間Wed Aug 27 17:39:53 2008
感謝大大回應~
～原來是我順序相反
只是我改順序之後如下
$delete = sprintf("DELETE FROM sales WHERE c_name in(SELECT C_name FROM
company WHERE CId in(%s))",
implode(",",$_POST['CId']));
$deleteSQL = sprintf("DELETE FROM company WHERE CId in(%s)",
implode(",",$_POST['CId']));
mysql_select_db($database_mio, $mio);
$Result1 = mysql_query($delete, $mio) or die(mysql_error());
$Result2 = mysql_query($deleteSQL, $mio) or die(mysql_error());
還是跑出上面那串錯誤訊息,我想可能是C_name是字串的原因,所以加了''於子查詢中
$delete = sprintf("DELETE FROM sales WHERE c_name in('SELECT C_name FROM
company WHERE CId in(%s)')",
這樣是沒有跑出錯誤訊息了～只是說銷售紀錄裡面的資料還是沒有背刪除....請問怎麼會
這樣呢？
--
※ 發信站: 批踢踢實業坊(ptt.cc)
◆ From: 220.132.218.94
1F：推 KC73:要不要先 echo $delete 和 $deleteSQL 給自己看看呀? 08/27 18:11