关键是SQL查询，您将其设置为字符串：
$sqlquery = "SELECT field1, field2 FROM table WHERE NOT columnA = 'x' AND NOT columbB = 'y'";
$sqlquery = "SELECT field1, field2 FROM table WHERE columnA != 'x' AND columbB != 'y'";
这是如何使用它的完整示例：
$link = MysqL_connect($dbHost,$dbUser,$dbPass) or die("Unable to connect to database");
MysqL_select_db("$dbName") or die("Unable to select database $dbName");
$sqlquery = "SELECT field1, field2 FROM table WHERE NOT columnA = 'x' AND NOT columbB = 'y'";
$result=MysqL_query($sqlquery);
while ($row = MysqL_fetch_assoc($result) {
//do stuff
}
您可以在上述while循环内做任何您想做的事情。作为元素访问表中的每个字段，$row array这意味着$row['field1']将为您提供field1当前行$row['field2']的值，并为您提供的值field2。
请注意，如果列中可能有NULL值，则使用上述两种语法都不会找到这些值。您将需要添加子句以包含NULL值：
$sqlquery = "SELECT field1, field2 FROM table WHERE (NOT columnA = 'x' OR columnA IS NULL) AND (NOT columbB = 'y' OR columnB IS NULL)";
602392714
清零编程群