Re: [PHP] PDO Error

2005-07-15 Thread Holografix
Yes, you're right. It's false This dont't work too. foreach ($dbh->query('SELECT * FROM words') as $row) { echo $row['word'] . ""; } But this works $stmt = $dbh->prepare('select * from words'); $stmt->execute(); $rows = $stmt->fetchAll(); echo count($rows) . ""; "Marek Kilimajer" <[EMAI

Re: [PHP] PDO Error

2005-07-15 Thread Marek Kilimajer
Holografix wrote: print_r($stmt) prints nothing. print($stmt) print nothing too. I checked errorCode() and it prints . Then it seems $stmt is false. var_dump() is more verbose about it. "Marek Kilimajer" <[EMAIL PROTECTED]> escreveu na mensagem news:[EMAIL PROTECTED] Holografix wro

Re: [PHP] PDO Error

2005-07-15 Thread Holografix
print_r($stmt) prints nothing. print($stmt) print nothing too. I checked errorCode() and it prints . "Marek Kilimajer" <[EMAIL PROTECTED]> escreveu na mensagem news:[EMAIL PROTECTED] > Holografix wrote: >> Hi Marek >> >> It's print_r($row), not print_r($stmt) ;) > > That's what I'm asking -

Re: [PHP] PDO Error

2005-07-15 Thread Marek Kilimajer
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" <[EMAIL PROTECTED]> escreveu na mensagem news:[EMAIL PROTECTED] Holografix wrote: Hi. When using this example

Re: [PHP] PDO Error

2005-07-15 Thread Holografix
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 fau

Re: [PHP] PDO Error

2005-07-15 Thread Holografix
Hi Marek It's print_r($row), not print_r($stmt) ;) "Marek Kilimajer" <[EMAIL PROTECTED]> escreveu na mensagem news:[EMAIL PROTECTED] > 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: >> >>

Re: [PHP] PDO Error

2005-07-15 Thread Georgi Ivanov
> 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=loc

Re: [PHP] PDO Error

2005-07-14 Thread Marek Kilimajer
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;db