The poll will have a few questions, each question with a few options / choices to pick from
Example Poll Q1 with choices True or False Q2 favorite color => choices Red / Black / Blue / none So on and so on.. Submit Poll Backend admin can create more than one poll at a time so data also needs to include poll_id, user_id, question_id, and choice_id (this data will then get pulled to create a chart) From: cake-php@googlegroups.com [mailto:cake-php@googlegroups.com] On Behalf Of polutan Sent: Friday, January 25, 2013 1:21 AM To: cake-php@googlegroups.com Subject: Re: Simple Poll hmmmm i think i need to fix your models as below : Poll hasMany Choice Choice hasMany ChoiceResult or PollResult That;s just my idea. Then...you should save your polling result to ChoiceResult model or choice_result table. choice_result table : id choice_id other_result sample data : id | choice_id | other_result 1 | 1 | NULL 2 | 2 | NULL 3 | 4 | "hmmm i don't know about that" 4 | 2 | NULL #notes: 4 is "Other" Next... you can find("count") WHERE choice_id = 1,2,3,4 2013/1/25 Advantage+ <movepix...@gmail.com> I need to create a simple poll for users and stumped on saving the results when user submits the poll. Poll hasMany Question Poll hasMany Result Question hasMany Choice Pretty simple, but how do you save the results since viewing the poll creates a form to save Poll? View the poll/$id pulls all the questions and choices for each, but how / where to save the results? What would be the correct table for this? poll_results? results? Thanks, Dave -- Like Us on FaceBook https://www.facebook.com/CakePHP Find us on Twitter http://twitter.com/CakePHP --- You received this message because you are subscribed to the Google Groups "CakePHP" group. To unsubscribe from this group and stop receiving emails from it, send an email to cake-php+unsubscr...@googlegroups.com <mailto:cake-php%2bunsubscr...@googlegroups.com> . To post to this group, send email to cake-php@googlegroups.com. Visit this group at http://groups.google.com/group/cake-php?hl=en. -- Coklat Stroberi -- Web Dev Training Centre http://www.facebook.com/pages/Coklat-Stroberi/249514251728226 (info lebih lanjut) http://coklatstroberi.net Jl. Raya Padang Luwih (Dalung) No.141 - Telp. (0361) 9006118 atau 08174128301 - Badung, Bali. Sebelah timur traffic light pertigaan perumahan dalung permai. -- Like Us on FaceBook https://www.facebook.com/CakePHP Find us on Twitter http://twitter.com/CakePHP --- You received this message because you are subscribed to the Google Groups "CakePHP" group. To unsubscribe from this group and stop receiving emails from it, send an email to cake-php+unsubscr...@googlegroups.com. To post to this group, send email to cake-php@googlegroups.com. Visit this group at http://groups.google.com/group/cake-php?hl=en. -- Like Us on FaceBook https://www.facebook.com/CakePHP Find us on Twitter http://twitter.com/CakePHP --- You received this message because you are subscribed to the Google Groups "CakePHP" group. To unsubscribe from this group and stop receiving emails from it, send an email to cake-php+unsubscr...@googlegroups.com. To post to this group, send email to cake-php@googlegroups.com. Visit this group at http://groups.google.com/group/cake-php?hl=en.
