stephen-d

I am switching to PDO and can't find an equivalent to mysql_num_rows.

Am I missing something silly?

Or is there a change of thinking needed for PDO?

How should I determine how many rows a query returned?

Thanks
Stephen

kevin

PDO returns an array, sizeof/count will get you home

Kevin
http://phpro.org

stephen-d

I would like to know how many rows I am working with before starting to
fetch.

Also fetchall, does not seem to have a style that returns each column
value just once. I see this ugly thing in the manual:

Fetch all of the remaining rows in the result set: Array (
[0] => Array (
[NAME] => pear
[0] => pear
[COLOUR] => green
[1] => green )
[1] => Array (
[NAME] => watermelon
[0] => watermelon
[COLOUR] => pink
[1] => pink
)

)

If I could get the column offsets only, without the column names I would be very happy.

Stephen

phpster

http://ca3.php.net/manual/en/pdostatement.rowcount.php

--

Bastien

Cat, the other other white meat

stephen-d

This is only good for updates, inserts and deletes.<br>

I am just doing a select.
Stephen<br>

phpster

my bad.

Note you can change the default return array behaviour by change the
FETCH_STYLE, default is both ordinal and col name

--

Bastien

Cat, the other other white meat