Tables:
booking: show_id (belongs_to: show)
show: name, venue_id (has_many :bookings belongs_to :venue)
venue: location, capacity ( has_many : shows)
NOW, I use this view,
<h1>Listing venue rank</h1>
<% @bookings.each do |booking| %>
<tr>
<td class="large box">
<%=h booking.show.venue.location %>
<br />
</tr></table>
it can get the booking venue list like that :
Listing venue rank
Location: www
Location: www
Location: weee
Location: weee
Location: www
but I want 2 make this page like that:
Listing venue rank
Location: www 3
Location: weee 1
I want to count the dupliate locations and show the number. I think it
will use distinct or count to modfy the controllers, but i do not figure
out. please give me some sugguestion.
class ShowsController < ApplicationController
def index
@shows = Show.find(:all, :order => "date")
@venue = Venue.find(:all)
class BookingsController < ApplicationController
def index
@bookings = Booking.find(:all, :order => "show_id, date")
@venue = Venue.find(:all)
@shows = Show.find(:all)
class VenuesController < ApplicationController
def index
@venues = Venue.all
--
Posted via http://www.ruby-forum.com/.
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "Ruby
on Rails: Talk" group.
To post to this group, send email to rubyonrails-talk@googlegroups.com
To unsubscribe from this group, send email to
rubyonrails-talk+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/rubyonrails-talk?hl=en
-~----------~----~----~----~------~----~------~--~---
