php - PHP数组：如何使用不同的值进行查询

Question

我有这个代码：

$sql='SELECT id FROM table1 WHERE "'.$date.'"=Date';
$result = mysqli_query($connect, $sql) or die(mysqli_error($connect));;
while($row = mysqli_fetch_array($result)){
    $c=$row['id'];
}

这将返回超过 1 个值。如何将不同的值用于另一个查询？前任：

$sql2='SELECT name FROM TABLE2 WHERE name="'.$c.'" ';

PS：我知道代码不好

标签： phpmysql

Answer 1

你是这个意思吗？不是100％肯定，但希望它有所帮助......

$sql='SELECT id FROM table1 WHERE Date = '.$date;
$result = mysqli_query($connect, $sql) or die(mysqli_error($connect));;
while($row = mysqli_fetch_array($result)){
    $sql2='SELECT name FROM TABLE2 WHERE name="'.$row['id'].'" ';
    $sub_result = mysqli_query($connect, $sql2) or die(mysqli_error($connect));
}