|
This question is related to this post: http://stackoverflow.com/questions/1764469/sql-design-for-survey-with-answers-of-different-data-types
I have a survey app where most questions have a set of answers that are 1-5. Now we have to do questions that ...
Answer Snippets (Read the full thread at stackoverflow):
Question_id INT NOT NULL, answer_id INT NOT NULL );
Create five columns in your answers table, each be tempted to store the answers as a comma-separated list of values in your string answer column question x with answer....
|
|
To input a square root type: Code: \sqrt{x} where x is the value inside the radicand
To input type: Code: \pi
A coordinate pair should be entered as: (x,y) Code: (4.2,5.2)
A fraction should be entered as x/y Code: 1/2
A mixed fraction should be entered...
Started by levans on
, 20 posts
by 13 people.
Answer Snippets (Read the full thread at artofproblemsolving):
Accept equivalent answers, especially ones that don't specify whether your answer should be expressed for the answer as a common fraction (3/10), and I gave the answer 0.3, which was accepted with floor functions asked for....
|
|
There is a scenario. There is an ask-and-answer website. An answerer can modify his answer, and the history of modification is saved on the server. Be default, only the latest version of each answer is displayed.
select * from answers where questionid...
Started by Steven on
, 4 posts
by 4 people.
Answer Snippets (Read the full thread at stackoverflow):
SELECT * FROM ( SELECT * FROM `answers * from answers where questionid='$questionid' and id in (select max(id) from answers group` WHERE questionid='$questionid' ORDER....
Query to re-arrange them so the latest answer is on top.
|
Ask your Facebook Friends
|
When using a pendulum to Divine answer to yes or no questions, why is it more demonstrative for the no answers. Do I need more practice? Do I need to reprogram the pendulum? This is so funny after asking these questions on the site, the device started...
Started by Tom on
, 11 posts
by 7 people.
Answer Snippets (Read the full thread at inwardquest):
Difficult to answer this without knowing and as Stingray says unattached....
Great answer :) Thanks all ....
The conflict is within.
You have taken yourself.
Thanks for you answers.
Time for a new one.
I just lost it, for good I think.
|
|
I have learned that SO has put questions and answers in the same table. They say that a question will not have a parent id and answers will have parent IDs. Why is it better to do it this way instead of putting questions and answers in separate tables...
Started by Luke101 on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at stackoverflow):
In particular One Question has many answers, but each answer belongs only to one questionSeveral reasons:
Conceptually questions and answers aren't really that different from a modelling to limit it to questions or ....
Not the same.
|
|
Yahoo answers cleaning up my answers? they are deleting my answers
Started by Ghislaine on
, 6 posts
by 6 people.
Answer Snippets (Read the full thread at yahoo):
Posting filler answers to a question in an effort to be first to answer, or copying and pasting otherReason:
community has reported....
Http://help.yahoo.com/l/us.
And Answer format
http://help.yahoo.com/l/us/yahoo/answers…
Cheating.
|
|
How can you use the following sample data either with a foreach or while -loop?
I get the following sample data by running
$answers = pg_fetch_all ( $result );.
Sample data
[0]=> array(3) { ["answer"]=> string(7) "This is the answer" ["username"...
Started by Masi on
, 4 posts
by 4 people.
Answer Snippets (Read the full thread at stackoverflow):
This is how you do the foreach loop
foreach ( $answers as $answer ){ echo $answer['answer'] echo of the second....
Foreach( $answers as $quess ) { $an = $quess['answer']; $name = $quess['username']; $time = $quess.
|
|
Do people at yahoo answers only accept the answers that they agree with and many times not the correct answer?
Started by The Spammers on
, 5 posts
by 5 people.
Answer Snippets (Read the full thread at yahoo):
While many people do will often pick a contradictory answer from which they were able to learn something new or gather to the question more than I am concerned with....
At or choose the answers that agree with or support their prior opinions.
|
|
Example scenarios:
I answer a question on Monday, then on Wednesday I come up with better, but completely different answer. Should I delete my original answer before I post another? What if both answers have merit?
I am answering a very broad question...
Started by too much php on
, 8 posts
by 8 people.
Answer Snippets (Read the full thread at stackoverflow):
Whether you edit or answer again, I dont answers in the....
I feel you should be able to post as many answers as you want.
Whether you edit or answer again).
I feel you should be able to post as many answers as you want.
|
|
I am developing an application based on questions and answers, and I would like to prevent a registered user from posting multiple answers to the same question.
How can I do that? And where is the best place to put this code (i.e. controller, model)?
Started by collimarco on
, 7 posts
by 6 people.
Answer Snippets (Read the full thread at stackoverflow):
And two, when a question is submitted, to check if there is already an answer by that....
If so, do not present him with the answer form.
You would need two checks, one when the questions loads to see if there is an answer by that user.
|
