How can the PHP code be modified to insert the names of the top 3 values in the correct order into the 'Winner' table?

To insert the names of the top 3 values in the correct order into the 'Winner' table, you can modify the PHP code to retrieve the top 3 values from the original table, sort them in descending order, and then insert them into the 'Winner' table accordingly. This can be achieved by using SQL queries to select the top 3 values and then insert them into the 'Winner' table with the correct order. 

<?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);
}

// Select top 3 values from the original table in descending order
$sql = "SELECT name FROM original_table ORDER BY value DESC LIMIT 3";
$result = $conn->query($sql);

// Insert the top 3 values into the 'Winner' table in the correct order
$position = 1;
while($row = $result->fetch_assoc()) {
    $name = $row['name'];
    $insert_sql = "INSERT INTO Winner (name, position) VALUES ('$name', $position)";
    $conn->query($insert_sql);
    $position++;
}

$conn->close();
?>

Keywords

PHP SQL database sorting INSERT statement

Related Questions