我有两个查询。第一个是生成我想在第二个查询中使用的id（col_id_8）的列表。我不确定我做错了什么。非常感谢。
$sql = 'SELECT DISTINCT col_id_8 FROM exp_channel_grid_field_84 WHERE entry_id = :entry_id';
$stmt = $conn->prepare($sql);
try {
$stmt->execute(array('entry_id' => $entry_id));
$result = $stmt->fetchAll(PDO::FETCH_ASSOC);
foreach ($result as $row) {
$fullcodes[] = $row['col_id_8'];
}
} catch(PDOException $e) { error_log($e->getMessage(),0); }
$sql = 'SELECT DISTINCT name FROM stix_live_orders WHERE code in (:allcodes) ORDER BY name ASC LIMIT 4';
$stmt = $conn->prepare($sql);
try {
$stmt->execute(array('allcodes' => $fullcodes));
$result = $stmt->fetchAll(PDO::FETCH_ASSOC);
# MORE CODE
}
尝试$stmt->execute(array('allcodes' => implode( ',', $fullcodes ) ));而不是$stmt->execute(array('allcodes' => $fullcodes));