Convert Array for mySQL Query

Question

I have two queries. The first one is generating a list of ids (col_id_8) I want to use in the second query. I'm not sure what I am doing wrong. Thank you!

$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
    }

you can do this in a single query using a subselect

Gerald Schneider
– Gerald Schneider

2014-11-09 16:57:59 +00:00
Commented Nov 9, 2014 at 16:57 — Gerald Schneider
– Gerald Schneider, Commented Nov 9, 2014 at 16:57

trzyeM- · Accepted Answer · 2014-11-09 16:55:21Z

2

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

answered Nov 9, 2014 at 16:55

trzyeM-

9638 silver badges10 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Aerdan Over a year ago

For some reason it didn't work there, but when I put it in the prepared statement it worked like a charm! Since this is a contained area, I'll just leave it :) Thank you!

Collectives™ on Stack Overflow

Convert Array for mySQL Query

1 Answer 1

1 Comment

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Related