howto get php PDO QUERY resultset in single array instead off nested in one

Question

I needed to change a query into a JOIN of two tables.

$q = "SELECT * FROM table1 AS a JOIN table2 AS b USING(id) WHERE a.id= $id";
$stmt = db::getInstance()->prepare($sql);
return $stmt->fetchAll(PDO::FETCH_ASSOC);

All off the sudden I cannot refer to each row value with $rows['value'] ,BUT I need to use $rows[0]['value'].

How can I avoid this behavior and get the values in the row without using [0]?

Thanks, Richard

Answer 1

How can I change this to use placeholders?

public function q($sql, $modus = FALSE)
    {   
        try
        {
            $stmt = db::getInstance()->prepare($sql);


        $stmt->execute();
        if( $modus ) return $rst = $modus == "row" ? $stmt->fetch(PDO::FETCH_OBJ) :  $stmt->fetchColumn();
        //else
        return $stmt->fetchAll(PDO::FETCH_ASSOC);
    }
    catch(Exception $e)
    {
        $this->fouten[] = $e->getMessage();
    }
}

Answer 2

If you expect only one row, use PDOStatement::fetch() instead of fetchAll().