# Questionairee's questions - how to show all user's answers? How to update database with ALL user's **URL:** \ **Category:** Rails\ **Created:** [May 23, 2010, 9:18pm UTC](https://www.ruby-forum.com/t/questionairees-questions-how-to-show-all-users-answers-how-to-update-database-with-all-users/189067 "2010-05-23T21:18:32Z")\ **Posts on this page:** 6\ **Page:** 1
**Author:** ![Smoq](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/s/ac91a4/32.png) [@Smoq](https://www.ruby-forum.com/u/Smoq)\ **Post date:** [May 23, 2010, 9:18pm UTC](https://www.ruby-forum.com/t/questionairees-questions-how-to-show-all-users-answers-how-to-update-database-with-all-users/189067/1 "2010-05-23T21:18:32Z")
I am using RoR 2.3.5. I would like to have list of questions with three possible answers. After having copleted a test I would like to update the database with user’s answers. At the bottom of the page I would also like to list all selected answers for the user. In a table “answers” I have columns: question, a1, a2, a3 (these columns are answers to the question), a\_u (user’s answer), a\_ok (correct answer). Below I have pasted the view that I am using for listing questions. But I have no idea how to list ALL answers at the bottom of the page (now I know how to show only one answer). And how (in the most effective way) to update the column “a\_u” wtith ALL user’s answers? Could you help me? #-----------------------------------------------------index.htm.erb begin------------------------------------------------------------------ # Listing answers \<% @answers.each do |answer| %\> \<%=h answer.question %\> \ /\> \<%=h answer.a1 %\> \ /\> \<%=h answer.a2 %\> \ /\> \<%=h answer.a3 %\> \<% end %\> You selected \<%= @data11 %\> #-----------------------------------------------------index.htm.erb end------------------------------------------------------------------ In answers\_controller I have included: ``` @data11 = params[:answer1] ``` ---
**Author:** ![Smoq](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/s/ac91a4/32.png) [@Smoq](https://www.ruby-forum.com/u/Smoq)\ **Post date:** [May 23, 2010, 10:56pm UTC](https://www.ruby-forum.com/t/questionairees-questions-how-to-show-all-users-answers-how-to-update-database-with-all-users/189067/2 "2010-05-23T22:56:52Z")
On 23 May 2010 17:52, Smoq [removed\_email\_address@domain.invalid](mailto:removed_email_address@domain.invalid) wrote: > In a table “answers” I have columns: question, a1, a2, a3 (these > columns are answers to the question), > a\_u (user’s answer), a\_ok (correct answer). Below I have pasted the > view that I am using for listing questions. Surely you have a “Question” model, which has the question text, and the three choices for answers (or even a “Choice” model, with a “Question :has\_may Choices” relationship…), and in the “Answer” model you just store the question\_id and the choice (or choice\_id). > But I have no idea how to list ALL answers at the bottom of the page > (now I know how to show only one answer). And how (in the most > effective way) to update the column “a\_u” wtith ALL user’s answers? For every question the user completes you have an Answer record (created when they answer a question, or updated if they’re allowed to edit), so users have many answers, and you can iterate to display all wherever you wish. ---
**Author:** ![Smoq](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/s/ac91a4/32.png) [@Smoq](https://www.ruby-forum.com/u/Smoq)\ **Post date:** [May 24, 2010, 8:43am UTC](https://www.ruby-forum.com/t/questionairees-questions-how-to-show-all-users-answers-how-to-update-database-with-all-users/189067/3 "2010-05-24T08:43:55Z")
On 23 Maj, 22:55, Michael P. [removed\_email\_address@domain.invalid](mailto:removed_email_address@domain.invalid) wrote: > model you just store the question\_id and the choice (or choice\_id). > > > ``` > > <%=h answer.question %> > >
> > > > ``` > > > > You received this message because you are subscribed to the Google G. “Ruby on Rails: Talk” group. > > To post to this group, send email to removed\_email\_address@domain.invalid. > > To unsubscribe from this group, send email to removed\_email\_address@domain.invalid. > > For more options, visit this group athttp://groups.google.com/group/rubyonrails-talk?hl=en. Hi, Could you let me know what shuld be included in controller to list on the page ALL user’s answers? I also think that the view should be modified to show ALL user’s answers - but I have no idea how it should be changed. Could you modify it? ---
**Author:** ![Smoq](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/s/ac91a4/32.png) [@Smoq](https://www.ruby-forum.com/u/Smoq)\ **Post date:** [May 24, 2010, 9:43am UTC](https://www.ruby-forum.com/t/questionairees-questions-how-to-show-all-users-answers-how-to-update-database-with-all-users/189067/4 "2010-05-24T09:43:02Z")
On 24 May 2010 07:42, Smoq [removed\_email\_address@domain.invalid](mailto:removed_email_address@domain.invalid) wrote: > Could you let me know what shuld be included in controller to list on > the page ALL user’s answers? You could populate a variable with the results of a find of the user’s answers, or just have a variable for the user and access “@user.questions” in the view. > I also think that the view should be > modified to show ALL user’s answers - but I have no idea how it should > be changed. Could you modify it? Are you asking me to _do_ your work for you for free?! ---
**Author:** ![Smoq](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/s/ac91a4/32.png) [@Smoq](https://www.ruby-forum.com/u/Smoq)\ **Post date:** [May 24, 2010, 11:44am UTC](https://www.ruby-forum.com/t/questionairees-questions-how-to-show-all-users-answers-how-to-update-database-with-all-users/189067/5 "2010-05-24T11:44:47Z")
On 24 Maj, 09:41, pavling [removed\_email\_address@domain.invalid](mailto:removed_email_address@domain.invalid) wrote: > > modified to show ALL user’s answers - but I have no idea how it should > > be changed. Could you modify it? > > Are you asking me to _do_ your work for you for free?! > > – > You received this message because you are subscribed to the Google G. “Ruby on Rails: Talk” group. > To post to this group, send email to removed\_email\_address@domain.invalid. Do you suggest that I shuld pay you for the answer? :). I am learnig RoR and I don’t know how to solve the problem - it is not my work BTW. ---
**Author:** ![Smoq](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/s/ac91a4/32.png) [@Smoq](https://www.ruby-forum.com/u/Smoq)\ **Post date:** [May 24, 2010, 2:53pm UTC](https://www.ruby-forum.com/t/questionairees-questions-how-to-show-all-users-answers-how-to-update-database-with-all-users/189067/6 "2010-05-24T14:53:16Z")
If I were you I would buy a book or find info on the web and study how activerecord associations work. That will most likely clear all your questions and help you solve the problem. The examples I’ve read in any of the books I have are very clear. Good books: Agile Web Development with Rails and The Rails Way. Good luck.