Question

我有两个表(问答表)。

<><> 问题>

id question
1  what is your name?
2  how old are you?

<>Answer>

id  answer  questionid
1   john     1
2   smith    1
3   waiyan   1
4   20       2
5   21       2
6   22       2

在我选定记录时,结果如下。

SELECT * FROM question INNER JOIN answer on questionid= question.id

what is your name?
john
what is your name?
smith
what is your name?
waiyan
how old are you?
20
how old are you?
21
how old are you?
22

I want to remove duplicate question statement. I want to get following.

What is your name?
John
smith
waiyan  

how old are you?  
20 
21    
22

Please Someone help me how to write it. I am really beginner for mysql. So sorry for my bad english usage.

Answer 1

这个问题载于您的《加拿大刑法》,而不是您的《我的瑞典国际法评论》。当问题与前一个问题不同时,你只需要印刷这个问题。这样做有很多办法。铭记在你的问询中,你需要:

SELECT * FROM question INNER JOIN answer 
    on questionid= question.id 
    order by question.id

确保同一问题的答案不会重复。然后做一些事情,如:

$last_question = "";
foreach ($results as $row) {
    if ($last_question !== $row["question.question"]) {
        echo $row["question.question"];
    }
    echo $row["answer.answer"];
    $last_question = $row["question.question"];
}

友情链接