# MySQL Query - Stupid question

**URL:** <https://www.ruby-forum.com/t/mysql-query-stupid-question/133927>\
**Category:** Ruby\
**Created:** [April 5, 2008, 1:49am UTC](https://www.ruby-forum.com/t/mysql-query-stupid-question/133927 "2008-04-05T01:49:47Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![sithadmin](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/s/858c86/32.png) [@sithadmin](https://www.ruby-forum.com/u/sithadmin)\
**Post date:** [April 5, 2008, 1:49am UTC](https://www.ruby-forum.com/t/mysql-query-stupid-question/133927/1 "2008-04-05T01:49:47Z")

</div>

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 M.

---

<div class="post-metadata">

**Author:** ![sithadmin](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/s/858c86/32.png) [@sithadmin](https://www.ruby-forum.com/u/sithadmin)\
**Post date:** [April 5, 2008, 4:16am UTC](https://www.ruby-forum.com/t/mysql-query-stupid-question/133927/2 "2008-04-05T04:16:02Z")

</div>

On Apr 4, 2008, at 4:49 PM, Jeff M. wrote:

> from  
> the table?
> 
> Thanks,
> 
> - Jeff M.

@new\_entries.num\_rows

---

<div class="post-metadata">

**Author:** ![sithadmin](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/s/858c86/32.png) [@sithadmin](https://www.ruby-forum.com/u/sithadmin)\
**Post date:** [April 19, 2008, 12:51am UTC](https://www.ruby-forum.com/t/mysql-query-stupid-question/133927/3 "2008-04-19T00:51:42Z")

</div>

Thanks, that worked.

However, I’m doing another query in a different app using RoR… How can  
I achieve the same thing? I want to get the number of rows off a query  
such as this:

@grab\_new\_entries = NewEntries.connection.select\_all(“SELECT displayname  
AS displayname FROM new\_entries”)

@grab\_new\_entries.num\_rows didn’t work…

Thanks,

- Jeff M.