|
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....
|
|
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.
|
|
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.
|
Ask your Facebook Friends
|
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.
|
|
This thread's a bit full so I'm starting a new one: http://answers.microsoft.com/en-us/feedback/forum/bug/answers-performance-problems/47fb7697-e7b9-4be8-8c24-4836f0330445 Delays in posts appearing and some posts will disappear for 15 or 20 minutes and...
Started by Le Boule on
, 13 posts
by 9 people.
Answer Snippets (Read the full thread at microsoft):
-steve Answers Forum still flaky I....
--- Yes, very frustrating dealing with Answers over the past week or so...
I just had one which ended to the same one all the time .
Answers Forum still flaky I'm glad you gave it a new topic too.
|
|
What's the difference between chatter answers and just regular answers?
Thanks,
Scott :)
Started by Scott.M on
, 5 posts
by 2 people.
Answer Snippets (Read the full thread at developerforce):
The underlying objects are the same, so the API is common but Chatter Answers has a lot more are the same why doesn't regular answers support the same features? Can a regular answers community also be a chatter answers community....
|
|
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.
|
|
Are people on yahoo answers aware that this site is amazing for quick answers?
Started by Azirus on
, 4 posts
by 4 people.
Answer Snippets (Read the full thread at yahoo):
|
|
In Yahoo answers is it possible to hide asked question but show my answers?
Started by Blake on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at yahoo):
Source(s): http://answers.yahoo.com/my-activity/edi.
answers visible; there is no setting for that.
|
|
How can I view all my questions and answers on yahoo answers ?
Started by lucia on
, 5 posts
by 5 people.
Answer Snippets (Read the full thread at yahoo):
Go to MY Activity then, click on MY Questions, it should be the second tab Go to your Yahoo Answers.
|
