How can I get from the database the number of records in which the list value is equal to element 1?

Question

PHP

Hello. I'll try to explain more clearly. There is a database, it has a table with records. Each entry contains a value from the list - 1, 2 or 3. I connected to the database and got the total number of entries in the table:

$sql = "SELECT * FROM cms_con_ls";
if($result = $conn->query($sql)){
    $rowsCount = $result->num_rows;

Thus I displayed the total number of records. How can I now make a correct database query to display only the number of records in which the list value is 1?

Answer 1

SELECT COUNT(*) FROM cms_con_ls WHERE status=1

Answer 2

In general, he did.

$conn = new mysqli("localhost", "пользователь", "пароль", "база");
$alls = $conn->query("SELECT COUNT(*) FROM cms_con_ls WHERE status=1");
$row = $alls->fetch_row();
$allso = $row[0];
echo $allso;

now it works as it should. Thanks everyone for the tips