Re: PDO Error

Holografix wrote:

Hi Marek It's print_r($row), not print_r($stmt) ;)

That's what I'm asking - If you put print_r($stmt) in that line, what does it print?

"Marek Kilimajer" <lists@kilimajer.net> escreveu na mensagem news:42D75E0F.8020203@kilimajer.net...

Holografix wrote:

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 $dbh = new PDO('mysql:host=localhost;dbname=dbtest', 'user', 'pass'); $stmt = $dbh->query("SELECT * FROM foo");

what does print_r($stmt); print here?

$rows = $stmt->fetchAll(); $count = count($rows); foreach ($rows as $row) { print_r($row); } $stmt = null; Wht's wrong with the example? Greetings holografix