0) { // Outputting the data while ($row = mysqli_fetch_assoc($result)) { echo "ID: " . $row["id"] . " - Name: " . $row["firstname"] . "
"; } } else { echo "0 results"; } // Close the connection mysqli_close($conn); ?>