Linking 2 Mysql tables with each other

rubyonrails-talk
1

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

2

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.

3

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 :slight_smile:

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 :slight_smile:

Thnx for replying already MaD