[SQL] Problem z PDO Opcje

[pawel.s]

[PHP] pobierz, plaintext 
<?php
witajcie moj problem to 
 
$dsn = 'mysql:dbname=test;host=127.0.0.1';
$user = 'root';
$password = 'root';
 
try {
    $dbh = new PDO($dsn, $user, $password);
} catch (PDOException $e) {
    echo 'Connection failed: ' . $e->getMessage();
}
 
$result = $dbh->prepare("SELECT * FROM users");
$result->execute();
 
to mam 
Fatal error: Call to a member function execute() on a non-object in /var/www/test.php on line 14
 
prosze o pomoc
?>
[PHP] pobierz, plaintext 

[vokiel]

[PHP] pobierz, plaintext 
<?php
// moze tak:
$dbh->prepare("SELECT * FROM users");
$result = $dbh->execute();
?>
[PHP] pobierz, plaintext