print_r($stmt) prints nothing. print($stmt) print nothing too. I checked errorCode() and it prints 0000. "Marek Kilimajer" <lists@xxxxxxxxxxxxx> escreveu na mensagem news:42D793E1.70906@xxxxxxxxxxxxxxxx > 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@xxxxxxxxxxxxx> escreveu na mensagem >> news:42D75E0F.8020203@xxxxxxxxxxxxxxxx >> >>>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 >>>> >> -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php