# Linking 2 Mysql tables with each other

**URL:** <https://www.ruby-forum.com/t/linking-2-mysql-tables-with-each-other/157495>\
**Category:** Rails\
**Created:** [January 12, 2009, 11:11am UTC](https://www.ruby-forum.com/t/linking-2-mysql-tables-with-each-other/157495 "2009-01-12T11:11:38Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![bubbie](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/b/a5b964/32.png) [@bubbie](https://www.ruby-forum.com/u/bubbie)\
**Post date:** [January 12, 2009, 11:11am UTC](https://www.ruby-forum.com/t/linking-2-mysql-tables-with-each-other/157495/1 "2009-01-12T11:11:38Z")

</div>

hello,

For school i’m making a website for music cd’s

I’m a beginner with RoR so I run into problems.  
At the moment I made 2 mysql tables, one with Genres and one with CD’s

when I click on the genre -\> show, then i’ll get the CD’s of that genre  
But when I want to show all the cd’s I got in my database I’m running  
into problems.

Cause i’ve linked all cd’s with a genre he needs an ID of a genre to  
link cd’s  
So I can’t link all the cd’s

I wanted to know if people know how to fix this problem

---

<div class="post-metadata">

**Author:** ![bubbie](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/b/a5b964/32.png) [@bubbie](https://www.ruby-forum.com/u/bubbie)\
**Post date:** [January 12, 2009, 11:44am UTC](https://www.ruby-forum.com/t/linking-2-mysql-tables-with-each-other/157495/2 "2009-01-12T11:44:24Z")

</div>

you just need to add an action show\_all to your controller.  
@cds = Cds.find(:all)

more is hard to tell from what information you are giving.

---

<div class="post-metadata">

**Author:** ![bubbie](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/b/a5b964/32.png) [@bubbie](https://www.ruby-forum.com/u/bubbie)\
**Post date:** [January 12, 2009, 1:23pm UTC](https://www.ruby-forum.com/t/linking-2-mysql-tables-with-each-other/157495/3 "2009-01-12T13:23:12Z")

</div>

Ok, a little bit more detail,

You have cd’s  
Every cd has a genre and an artist  
You want 3 differente queries  
1: a list of all the Cd’s with a link where you can add new Cd’s  
2: @ genre, you can select a genre and get a list of all the cd’s with  
that genre  
3: @ artist, you can select an artist and get a list of all the cd’s of  
that artist.

Hope this helps abit 🙂

A search querie would be nice aswell, that you search on an artist and  
get all the cd’s of that artist, but thats for later on 🙂

Thnx for replying already MaD