MySQL ResultSet - count rows?



Hello,

I am writing the data of a ResultSet object to an array. To declare
the array length, I need to know the number of rows before copying
them - is there a way to read the row count instantly, without having
to iterate anything?

PHP has mysql_count_rows, but I'm not sure what that does internally -
it may just iterate over the data too.

--
Chris
.



Relevant Pages

  • Re: [ANN] Rio 0.3.4
    ... > Will a modification of IRB with RIO, and a few other things, possibly result ... >> Ways to get the chomped lines of a file into an array ... >> Iterate over only the files in a directory ... >> * New Grande Selection parameter. ...
    (comp.lang.ruby)
  • [ANN] Rio 0.3.4
    ... Rio is a Ruby I/O convenience class wrapping much of the functionality ... Copy or append a file to a string ... Ways to get the chomped lines of a file into an array ... Iterate over only the files in a directory ...
    (comp.lang.ruby)
  • [ANN] Rio 0.3.7
    ... Rio is a Ruby I/O convenience class wrapping much of the functionality ... Copy or append a file to a string ... Ways to get the chomped lines of a file into an array ... Iterate over only the files in a directory ...
    (comp.lang.ruby)
  • Re: MySQL ResultSet - count rows?
    ... the array length, I need to know the number of rows before copying ... it may just iterate over the data too. ... So in that sense PHP and JDBC are identical. ...
    (comp.lang.java.databases)
  • [ANN] Rio 0.4.1
    ... = Rio - Ruby I/O Facilitator ... Iterate over the .rb files in a directory and its subdirectories. ... Return an array of the .rb files in a directory and its ... Copy or append a file to a string ...
    (comp.lang.ruby)