Re: PDO Question. Number of rows returned

On Sun, Jul 13, 2008 at 11:12 AM, Stephen <stephen-d@rogers.com> wrote: > Bastien Koert wrote: > > On Sun, Jul 13, 2008 at 10:30 AM, Stephen <stephen-d@rogers.com> > <stephen-d@rogers.com> wrote: > > > > Kevin Waterson wrote: > > > > 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? > > > > > PDO returns an array, sizeof/count will get you home > > > > > 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 > > > > > http://ca3.php.net/manual/en/pdostatement.rowcount.php > > This is only good for updates, inserts and deletes. > > I am just doing a select. > Stephen > > 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