# How to get count of records from database?

**URL:** <https://www.ruby-forum.com/t/how-to-get-count-of-records-from-database/94589>\
**Category:** Rails\
**Created:** [May 8, 2006, 1:51pm UTC](https://www.ruby-forum.com/t/how-to-get-count-of-records-from-database/94589 "2006-05-08T13:51:24Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![tiwaripk](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/t/7ab992/32.png) [@tiwaripk](https://www.ruby-forum.com/u/tiwaripk)\
**Post date:** [May 8, 2006, 1:51pm UTC](https://www.ruby-forum.com/t/how-to-get-count-of-records-from-database/94589/1 "2006-05-08T13:51:24Z")

</div>

Hi,

I want to display count of all records with particular field value from  
database onto my view. How should I do that?  
PLs tell me.  
Thanx.  
Prash

---

<div class="post-metadata">

**Author:** ![tiwaripk](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/t/7ab992/32.png) [@tiwaripk](https://www.ruby-forum.com/u/tiwaripk)\
**Post date:** [May 8, 2006, 1:58pm UTC](https://www.ruby-forum.com/t/how-to-get-count-of-records-from-database/94589/2 "2006-05-08T13:58:46Z")

</div>

> I want to display count of all records with particular field value from  
> database onto my view. How should I do that?

I think you can do it as follows:

in yr controller:

@count = [model\_to\_be\_queried].find(:all, [“field\_name = ?”,  
value]).size

and then use \<%=h @count %\> in your view

So for all records in your chicken table with 10 eggs

@count = Chicken.find(:all, [“eggs = ?”, 10]).size

---

<div class="post-metadata">

**Author:** ![tiwaripk](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/t/7ab992/32.png) [@tiwaripk](https://www.ruby-forum.com/u/tiwaripk)\
**Post date:** [May 8, 2006, 2:42pm UTC](https://www.ruby-forum.com/t/how-to-get-count-of-records-from-database/94589/3 "2006-05-08T14:42:35Z")

</div>

If you only want the number of records it will be a lot faster to use  
count rather than find as AR won’t have to instantiate all the  
objects.

Person.count :conditions =\> [‘age = ?’, 29]

[http://api.rubyonrails.org/classes/ActiveRecord/Calculations/ClassMethods.html#M000823](http://api.rubyonrails.org/classes/ActiveRecord/Calculations/ClassMethods.html#M000823)

-Jonny.

---

<div class="post-metadata">

**Author:** ![tiwaripk](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/t/7ab992/32.png) [@tiwaripk](https://www.ruby-forum.com/u/tiwaripk)\
**Post date:** [May 8, 2006, 2:45pm UTC](https://www.ruby-forum.com/t/how-to-get-count-of-records-from-database/94589/4 "2006-05-08T14:45:54Z")

</div>

# Controller

@cheese\_number = Cheese.count(:conditions =\> “colour = ‘red’”)

# View

\<%= @cheese\_numer %\>

Cheers

## Jonathan

> **[AgileEvolved.com is for sale | HugeDomains](https://www.hugedomains.com/domain_profile.cfm?d=agileevolved.com)**
>
> Own this domain today. We make your shopping experience easy. Friendly and quick customer service.