首先，让我告诉你，我是PHP和MySQL的新手，并试图学习。因此，我创建了一个网络应用程序，其中一个随机的公寓号码将显示对一个人的名字排序的会员号码的资历。公寓号和人名来自不同的表。我可以通过这样的查询得到一个随机的名字-

SELECT bd, rank, name FROM person ORDER BY RAND() DESC LIMIT 1

但我需要的是-当我提交表格时，它会显示最资深的人的名字和一个随机的公寓号码，当我点击再次提交表格时，然后是下一个资深的人和一个随机的公寓号码，等等。那么，我的疑问应该是什么呢？我的代码看起来像这样-

if (isset($_POST['submit'])) {
$query = "SELECT house_no FROM houses ORDER BY RAND() LIMIT 1";
$result = mysqli_query($link, $query);
while ($row = mysqli_fetch_array($result))
{
    global $won;
    $won = $row['house_no'];
    echo $won;
}

$query2 = "SELECT bd, rank, name FROM person ORDER BY RAND() DESC LIMIT 1";
$result2 = mysqli_query($link, $query2);
while ($row2 = mysqli_fetch_array($result2))
{
    $winner_rank = $row2['rank'];
    $winner = $row2['name'];
    $winner_bd = $row2['bd'];
    global $winner, $winner_bd, $winner_rank;

    echo $row2['rank']. " ";
    echo $row2['name']. ", ";
    echo "Member No/".$row2['bd'];
} }