Question

我是否可采用以下逻辑守则来实际工作?

$sql=mysql_query("DELETE FROM users WHERE id= 3,4,5,9 ");

我基本上想给我的用户一个衡量所有显示的行文的tick子,然后他们可以选择哪几行去除。我只想用 specified子去掉一个多头吗?

任何想法?

Answer 1

什么是:

$sql=mysql_query("DELETE FROM users WHERE id IN (3, 4, 5, 9)");

规定:

your ids are numeric in the DB
you want to delete user 3, and delete user 4, and delete user 5, and delete user 9

当然,如果你的孩子有:

$sql=mysql_query("DELETE FROM users WHERE id IN ( 3 ,  4 ,  5 ,  9 )");

详情见:

Answer 2

您可使用IN。

DELETE ... WHERE id IN (3,4,5,9)

Answer 3

使用<代码>WHERE IN条款。

DELETE FROM users WHERE id IN (3, 4, 5, 9);

Answer 4

您是否使用<条码>IN

DELETE FROM users WHERE id IN (3,4,5,9)

虽然我在申请中从未删除任何内容。我的旗帜是假的。

UPDATE users set active=0 where id in (3,4,5,9)

然后,所有查询都有一个<代码>active=1<>/code>和1>的违约值。

Answer 5

您可使用<代码>in而不是=。

例如,

DELETE FROM users WHERE id IN (3,4,5,9);

Answer 6

$sql=mysql_query("DELETE * FROM table WHERE id IN (3,4,5,9)");