PDO query

[doddsey_65]

in my attempts at PDO i seem to have gone wrong here. perhaps someone can help:

 

$query = "SELECT *
                FROM ".TBL_PREFIX."users
                WHERE u_uid=$uid";
        $stmt = $link->query($query);
        $result = $stmt->fetch(PDO::FETCH_ASSOC);
        
        foreach($result as $key => $val)
        {
            echo $key.' - '.$val.'<br />';
        }

 

this is the error:

 

Fatal error: Call to a member function fetch() on a non-objec

 

$link = new PDO("mysql:host={$settings['hostname']};
                        dbname={$settings['database']}",
                            $config['database']['username'],
                            $config['database']['password']
                            );

[BlueSkyIS]

Fatal error: Call to a member function fetch() on a non-objec

 

please post the entire error, including one of the most important parts: the LINE NUMBER