MySQL COUNT()或SUM()

Question

我搜索了一个运行良好的城市：

$sql = "`status`,`name`,`zip`,`city`, `xxx`, `yyy`";

$geo = "(".$radius." * SQRT(2*(1-cos(RADIANS(breit)) * 
cos(".$rad_b.") * (sin(RADIANS(lang)) * 
sin(".$rad_l.") + cos(RADIANS(lang)) * 
cos(".$rad_l.")) - sin(RADIANS(breit)) * 
sin(".$rad_b."))))";

$select = "SELECT $sql, $geo AS distance FROM TABLE Having 
((distance <= '".$area."') or (distance <= 20 && `city` = '".$city."')) && 
`status` BETWEEN '1' AND '10' 
ORDER BY `city` = '".$city."' DESC, distance, RAND()";

$result = mysqli_query($db,$select);

现在我想数一下有多少xxx字段的值是1。有谁有解决方案吗？

谢谢JK

Answer 1

你可以使用

SELECT COUNT(1) FROM table WHERE value = 1

$select1 = "SELECT COUNT(1) FROM table WHERE xxx = 1 HAVING
((distance <= '".$area."') OR (distance <= 20 && `city` = '".$city."'))
ORDER BY `city` = '".$city."' DESC, distance, RAND()";

$result1 = mysqli_query($db,$select1);

通过这种方式，您应该在$result1变量中获得值

or (distance <= 20 && city = '".$city."')) && status介于'1‘和'10’之间的ORDER BY city = '".$city."‘DESC，distance，RAND()