On 13 June 2011 18:33, Yennie <[email protected]> wrote: > @id = User.find(:all, :select => 'users.id') > @id.each do |i| > @pic = ActiveRecord::Base.connection.select_value( > select picture > from albums a > inner join Users u > on u.id = a.id > where u.id = i ) > end > end > > please give me some advices...
Assuming your users have a "has_many :pictures" relationship: @pictures = User.all.map(&:pictures).flatten Or if your Users have many Albums, and Albums have many Pictures: @pictures = User.all.map(&:albums).flatten.map(&:pictures).flatten (can probably use .inject to make that smaller, but you can look that up in the api docs) then you can iterate @pictures however you want in your views. but.... hang on... Aren't you just getting a list of all the Pictures? Why not use "Picture.all"? -- 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 [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en.
