How can the PHP script be improved to correctly update the "rang" field based on the sorted "score" values in the "TABELLE1" table?

The PHP script can be improved by querying the database to retrieve the sorted scores from the "TABELLE1" table, updating the "rang" field based on the order of the scores, and then updating the database with the new "rang" values. This can be achieved by using a SQL query to fetch the scores in descending order and then updating the "rang" field accordingly. 

<?php
// Connect to the database
$servername = "localhost";
$username = "username";
$password = "password";
$dbname = "database";

$conn = new mysqli($servername, $username, $password, $dbname);

// Check connection
if ($conn->connect_error) {
    die("Connection failed: " . $conn->connect_error);
}

// Query to fetch sorted scores
$sql = "SELECT id, score FROM TABELLE1 ORDER BY score DESC";
$result = $conn->query($sql);

if ($result->num_rows > 0) {
    $rank = 1;
    // Update 'rang' field based on sorted scores
    while($row = $result->fetch_assoc()) {
        $id = $row['id'];
        $sql_update = "UPDATE TABELLE1 SET rang = $rank WHERE id = $id";
        $conn->query($sql_update);
        $rank++;
    }
    echo "Rang field updated successfully";
} else {
    echo "No records found";
}

$conn->close();
?>

Keywords

PHP SQL UPDATE query ORDER BY sorting

Related Questions