从查询中订购重新发布的问题

Question

我正在尝试在查询循环内订购第二个查询，但似乎无法正常工作。我真正想要实现的是按ID对行进行订购，但是在第二个查询中却行不通。这是代码：<table><?phpfunction convertToHoursMins($time, $format = '%02d:%02d') {    if ($time < 1) {        return;    }    $hours = floor($time / 60);    $minutes = ($time % 60);    return sprintf($format, $hours, $minutes);}$servername = "xxxx";$username = "xxxxx";$password = "xxxx";$dbname = "xxx";// Create connection$conn = new mysqli($servername, $username, $password, $dbname);// Check connectionif ($conn->connect_error) {    die("Connection failed: " . $conn->connect_error);} if(!$_GET["steam"]){    $steam = $steamprofile['steamid'];}else{    $steam = intval($_GET["steam"]);}$sql = "SELECT * FROM `TotalVIPs`";$conn->set_charset("utf8");$result = $conn->query($sql);if ($result->num_rows > 0) {    // output data of each row    while($row = $result->fetch_assoc()) {        //echo " <tr><th>". $row["SteamID"]."</th><td></tr>";        $sql2 = "SELECT * FROM `PlayedTime` WHERE `steamid` LIKE '". $row["SteamID"] ."' ORDER BY id ASC";        $conn->set_charset("utf8");        $result2 = $conn->query($sql2);        if ($result2->num_rows > 0) {            while($row2 = $result2->fetch_assoc()) {                $time = $row2["AllTotal"];                $convtime = convertToHoursMins($time, '%d ore %d min');                $steamprof = "<a href='profile.php?steam=" . $row2["communityid"]. "' class='btn btn-default btn-xs'>Profil</a>";                echo " <tr><th>". $row2["id"]."</th><td>". $row2["playername"]."</td><td>". $row2["steamid"]."</td><td>". $convtime ."</td><td>". $row2["last_accountuse"]."</td><td>" . $steamprof . "</tr>";            }        }    }}$conn->close();?> </table>我希望它按ID排序，但由于某种原因不这样做。在这里，一张照片：http : //prntscr.com/neuu74