Re: PDO Error

Hi Georgi From php manual: PDO::query Executes an SQL statement, returning a result set as a PDOStatement object () object PDO::query ( string statement ) So, $stmt shoul be an object. Thanks four your answers. I will post a more detailed message in php-db where this problem belongs. My fault posted it in php-general. Greetings "Georgi Ivanov" <joro@abacustrade.com> escreveu na mensagem news:200507151222.16331.joro@abacustrade.com... >> Hi. When using this example from >> http://netevil.org/talks/index.php?t=pdo&s=20, the site >> of pdo's author I >> have this error: >> >> Fatal error: Call to a member function fetchAll() on a non-object in >> /www/home/testes/pdo_my1.php on line 17 >> >> > Object creation : >> $dbh = new PDO('mysql:host=localhost;dbname=dbtest', 'user', >> 'pass'); >> $stmt = $dbh->query("SELECT * FROM foo"); > Here I think $stmt is NOT an object. > $stmp should be RESOURCE or boolean value most likely. > So it should be $rows=$dbh->fetchAll(); >> $rows = $stmt->fetchAll(); >> $count = count($rows); >> foreach ($rows as $row) { >> print_r($row); >> } >> $stmt = null; >> >> Wht's wrong with the example? >> >> Greetings >> holografix > > -- > Regards > Georgi Ivanov