作者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