您编写代码尝试计算所有字段都不为null的行数。您应该使用
is not null而不是仅仅使用
not null。
要计算字段数，请使用以下命令：
SELECt sum((listing_photo_1 IS NOT NULL) +(listing_photo_2 IS NOT NULL) +(listing_photo_3 IS NOT NULL) +(listing_photo_4 IS NOT NULL) +(listing_photo_5 IS NOT NULL) +(listing_photo_6 IS NOT NULL) +(listing_photo_7 IS NOT NULL) +(listing_photo_8 IS NOT NULL) ) as totalfrom listingsWHERe pmpid = '$pmpid';
要计算行数：
SELECt count(*) as totalfrom listingsWHERe listing_photo_1 IS NOT NULL AND listing_photo_2 IS NOT NULL AND listing_photo_3 IS NOT NULL AND listing_photo_4 IS NOT NULL AND listing_photo_5 IS NOT NULL AND listing_photo_6 IS NOT NULL AND listing_photo_7 IS NOT NULL AND listing_photo_8 IS NOT NULL AND pmpid = '$pmpid'";
编辑：
如果它们为空，请使用如下逻辑：
SELECt sum((listing_photo_1 IS NOT NULL and listing_photo_1 <> '') +(listing_photo_2 IS NOT NULL and listing_photo_2 <> '') +(listing_photo_3 IS NOT NULL and listing_photo_3 <> '') +(listing_photo_4 IS NOT NULL and listing_photo_4 <> '') +(listing_photo_5 IS NOT NULL and listing_photo_5 <> '') +(listing_photo_6 IS NOT NULL and listing_photo_6 <> '') +(listing_photo_7 IS NOT NULL and listing_photo_7 <> '') +(listing_photo_8 IS NOT NULL and listing_photo_8 <> '') ) as totalfrom listingsWHERe pmpid = '$pmpid';
