How can one modify a SQL query in PHP to include additional columns like "mitarbeiternr" when using "COUNT(*)"?

When using "COUNT(*)" in a SQL query in PHP, you can modify the query to include additional columns by using the "GROUP BY" clause. This allows you to group the results by a specific column, such as "mitarbeiternr", while still counting the total number of rows. By including the additional column in the "GROUP BY" clause, you can get the count of rows for each unique value in that column. 

$query = "SELECT mitarbeiternr, COUNT(*) AS count FROM table_name GROUP BY mitarbeiternr";
$result = mysqli_query($connection, $query);

if(mysqli_num_rows($result) > 0) {
    while($row = mysqli_fetch_assoc($result)) {
        echo "Mitarbeiternr: " . $row['mitarbeiternr'] . " - Count: " . $row['count'] . "<br>";
    }
} else {
    echo "No results found.";
}

Keywords

PHP SQL query COUNT(*) additional columns mitarbeiternr

Related Questions