Re: [SQL ] 請問這個mysql語法哪邊出了錯誤呢

[chrismaggie (中仔)]

感謝大大回應~
～原來是我順序相反
只是我改順序之後如下
$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
推 KC73:要不要先 echo $delete 和 $deleteSQL 給自己看看呀?