php - Convert Array for mySQL Query -

php - Convert Array for mySQL Query -

i have 2 queries. first 1 generating list of ids (col_id_8) want utilize in sec query. i'm not sure doing wrong. give thanks you!

$sql = 'select distinct col_id_8 exp_channel_grid_field_84 entry_id = :entry_id'; $stmt = $conn->prepare($sql); seek { $stmt->execute(array('entry_id' => $entry_id)); $result = $stmt->fetchall(pdo::fetch_assoc); foreach ($result $row) { $fullcodes[] = $row['col_id_8']; } } catch(pdoexception $e) { error_log($e->getmessage(),0); } $sql = 'select distinct name stix_live_orders code in (:allcodes) order name asc limit 4'; $stmt = $conn->prepare($sql); seek { $stmt->execute(array('allcodes' => $fullcodes)); $result = $stmt->fetchall(pdo::fetch_assoc); # more code }

try $stmt->execute(array('allcodes' => implode( ',', $fullcodes ) )); instead $stmt->execute(array('allcodes' => $fullcodes));

php mysql