# Identifying specific mysql tables

**URL:** <https://discuss.rubyonrails.org/t/identifying-specific-mysql-tables/25396>\
**Category:** rubyonrails-talk\
**Created:** [February 25, 2008, 5:35am UTC](https://discuss.rubyonrails.org/t/identifying-specific-mysql-tables/25396 "2008-02-25T05:35:15Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![James\_Brooks](https://avatars.discourse-cdn.com/v4/letter/j/a5b964/32.png) [@James\_Brooks](https://discuss.rubyonrails.org/u/James_Brooks)\
**Post date:** [February 25, 2008, 5:35am UTC](https://discuss.rubyonrails.org/t/identifying-specific-mysql-tables/25396/1 "2008-02-25T05:35:15Z")

</div>

Hi Kevin,

Are you looking to show the data from those tables on that page (say the tables are called cats and dogs)? The basic rails idiom for this is:

controller:

def list

@cats = Cat.find(:all)

@dogs = Dog.find(:all)

end

view:

\<% @cats.each do |cat| %\>

some display code here

\<% end %\>

and repeat for @dogs.

Cheers,

James

---

<div class="post-metadata">

**Author:** ![11175](https://avatars.discourse-cdn.com/v4/letter/1/8edcca/32.png) [@11175](https://discuss.rubyonrails.org/u/11175)\
**Post date:** [February 26, 2008, 1:40am UTC](https://discuss.rubyonrails.org/t/identifying-specific-mysql-tables/25396/2 "2008-02-26T01:40:14Z")

</div>

James,

Thank you for your feedback, the example gave me nice insight.

Resolved 🙂 Have a good week!