我正在尝试获取我在$sql = "";中选择的每一行的结果但我没能成功。尝试了不同的代码，但都不起作用。这是我的代码：
$sql2 = "SELECT player1, player2, player3, player4, player5, player6, player7, player8, player9, player10, player11, player12, player13, player14, player15, player16, player17, player18, player19, player20, player21, player22, player23, player24 FROM `savedpacks` WHERE `packid`=" . $_GET['id'] . "";
$result2 = $conn->query($sql2);
while( $row2 = mysqli_fetch_assoc( $result2)) {
$sql = "SELECT * FROM `players_db` WHERE `id`=" . $row2['player1'] . "";
$result = $conn->query($sql);
$row = mysqli_fetch_assoc( $result);
if ($row['Revision'] != 0) {`
我试图得到每一行的结果，所以player1，player2，等等。但正如你所看到的，我只得到了player1的那一行。我希望有人能帮我。谢谢
用于循环内部，而循环类似于
$sql2 = "SELECT player1, player2, player3, player4, player5, player6, player7, player8, player9, player10, player11, player12, player13, player14, player15, player16, player17, player18, player19, player20, player21, player22, player23, player24 FROM `savedpacks` WHERE `packid`=" . $_GET['id'] . "";
$result2 = $conn->query($sql2);
while( $row2 = mysqli_fetch_assoc( $result2)) {
for($i=1;$i<=24;$i++)
{
$sql = "SELECT * FROM `players_db` WHERE `id`=" . $row2['player'.$i] . "";
$result = $conn->query($sql);
$row = mysqli_fetch_assoc( $result);
if ($row['Revision'] != 0) {`...}
}
您可以这样使用：
$sql2 = "You Query";
$players = array();
$result2 = $conn->query($sql2);
while($row2 = $result->fetch_assoc()) {
$players[] = $row2;
}
foreach ($players as $key => $value) {
$sql = "SELECT * FROM `players_db` WHERE `id`=" . $value . "";
}
将值存储到数组中，然后使用foreach循环并为每次迭代获取$value。
您可以使用此的联接查询
$sql = "SELECT * FROM players_db as P join savedpacks as S on (S.id = P.player1 || S.id = P.player2 || S.id = P.player3 || S.id = P.player4 || S.id = P.player5 || S.id = P.player6 || S.id = P.player7 || S.id = P.player8 || S.id = P.player9 || S.id = P.player10 || S.id = P.player11 || S.id = P.player12 || S.id = P.player13 || S.id = P.player14 || S.id = P.player15 || S.id = P.player16 || S.id = P.player17 || S.id = P.player18 || S.id = P.player19 || S.id = P.player20 || S.id = P.player21 || S.id = P.player22 || S.id = P.player23 || S.id = P.player24) where S.packid=" . $_GET['id'] . "";
您可以在单个查询iteslf中获得结果，而不是使用两个查询