Top "Fetchall" questions

php PDO fetchAll() - while not working, foreach works

I would like to know if i'm doing fine OR fetchAll() doesn't work with WHILE. here is an exemple $db=…

php pdo foreach while-loop fetchall

Fatal error: Call to undefined method mysqli_result::fetch_all()

I have problems with PHP in Ubuntu 10.04. When I try use mysqli_result::fetch_all this error appears: Call to …

php mysqli fetchall mysqlnd

python postgres can I fetchall() 1 million rows?

I am using psycopg2 module in python to read from postgres database, I need to some operation on all rows …

python postgresql fetchall

PDO looping throug and printing fetchAll

I'm having trouble getting my data from fetchAll to print selectively. In normal mysql I do it this way: $rs = …

php mysql database pdo fetchall

About mysql cursor and iterator

Imagine I have a mysql cursor and data read. The amount of data might be very big that I want …

python mysql cursor fetchall

Symfony Doctrine : get field value in foreach loop on fetchAll()

I'm trying to display some fields of a table 'Post' using a raw query : $connection = $em->getConnection(); $statement = $connection-&…

symfony doctrine-orm fetchall

How do I use fetchAll in php?

I am using this statement to fetch the elements in a column in my db $result = $stmt->fetchAll(PDO::…

php sql fetchall

[zend][db] fetchAll with multiple variables

I'm trying to use fetchAll on a query that has 2 variables. I can't figure out the syntax. I can manage …

zend-framework zend-db parameterized fetchall

Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[HY000]: General error' in

I have this function and it keeps giving out the error "Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[HY000]: …

php mysql pdo fetch fetchall

Why is the same SQLite query being 30 times slower when fetching only twice as many results?

I have been working on speeding up a query I'm using for about a week now and asked several questions …

python performance sqlite fetchall