From: "s.ross" <cwdinfo@...>
Date: 2008-04-05T11:14:49+09:00
Subject: Re: MySQL Query - Stupid question...

On Apr 4, 2008, at 4:49 PM, Jeff Miller wrote:

> Hello,
> Although I've dealt with many many SQL queries and whatnot, I actually
> don't know how to return the number of rows it returned... I'm using  
> the
> MySQL gem and making my queries like this:
>
> db1 = Mysql.connect("localhost", "root", "root", "project")
> @new_entries = db1.query("SELECT * FROM new_entries")
>
> ...but what can I do to get the number of rows as well as the data  
> from
> the table?
>
> Thanks,
> - Jeff Miller

@new_entries.num_rows