How can PHP be used to group data by the first letter of a specific field, such as a last name, in a database query?

To group data by the first letter of a specific field, such as a last name, in a database query using PHP, you can use the SQL `GROUP BY` clause along with the `LEFT()` function to extract the first letter of the field. This will allow you to group the data based on the first letter of the specified field. 

// Assuming $db is your database connection

$query = "SELECT LEFT(last_name, 1) AS first_letter, COUNT(*) AS count
          FROM your_table
          GROUP BY first_letter
          ORDER BY first_letter";

$result = $db->query($query);

if ($result->num_rows > 0) {
    while ($row = $result->fetch_assoc()) {
        echo $row['first_letter'] . ": " . $row['count'] . "<br>";
    }
} else {
    echo "No results found.";
}

Keywords

PHP database query grouping data first letter last name

Related Questions