Forum: Ruby on Rails Linking 2 Mysql tables with each other

Announcement (2017-05-07): www.ruby-forum.com is now read-only since I unfortunately do not have the time to support and maintain the forum any more. Please see rubyonrails.org/community and ruby-lang.org/en/community for other Rails- und Ruby-related community platforms.
228cf28f5f4846e3209bb14886369218?d=identicon&s=25 Remco Gubbels (bubbie)
on 2009-01-12 11:11
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
80e4cb97cae5c8d745f72337d93fd8f2?d=identicon&s=25 MaD (Guest)
on 2009-01-12 11:44
(Received via mailing list)
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.
228cf28f5f4846e3209bb14886369218?d=identicon&s=25 Remco Gubbels (bubbie)
on 2009-01-12 13:23
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
This topic is locked and can not be replied to.