php - Mysql的select返回了多少行？

Question

你能建议我如何计算 Mysql select 中返回的行数吗？

$n_quakes = "SELECT COUNT(*) 
             FROM earthquakes 
             WHERE milliseconds >= 1000 
               AND milliseconds <= 2000 
               AND magnitude >= 4 
               AND magnitude <= 8 
               AND ipocentro >= 50 
               AND ipocentro <= 800 
               AND latitude >= 40 
               AND latitude <= 50 
               AND longitude >= 30 
               AND longitude <= 70";

这样我就知道行数了？

在我的代码中不起作用，但我不知道这是错误还是在代码的其他位置。

感谢您的帮助，对我的英语表示抱歉

Answer 1

尝试在

之间使用此方法

$count = mysqli_fetch_array(mysqli_query($coni, "SELECT COUNT(*) as totalCount
             FROM earthquakes 
             WHERE (milliseconds between 1000 and 2000) and (magnitude between 4 and 8) AND (ipocentro between 50 and 800) AND (latitude between 40 and 50) and (longitude between 30 and 70)"));

$actualCount =  $count['totalCount'];