How can the issue of only displaying the first record when clicking the submit button in a PHP application be troubleshooted and resolved?

Issue: The problem of only displaying the first record when clicking the submit button in a PHP application can be troubleshooted and resolved by ensuring that the code retrieves and displays all records from the database, instead of just the first one.

// Retrieve and display all records from the database
$query = "SELECT * FROM your_table";
$result = mysqli_query($conn, $query);

// Display all records
while($row = mysqli_fetch_assoc($result)) {
    echo $row['column_name'] . "<br>";
}