没有重复记录的内连接

Question

我有两张表（问题表和答案表）。

问题表

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

答案表

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

我想删除重复的问题陈述。 我想追随。

What is your name?
John
smith
waiyan  

how old are you?  
20 
21    
22

请有人帮我如何写。 我真的是mysql的初学者。 很抱歉我的英语用法不好。

Answer 1

问题出在你的 php 代码中，而不是你的 MySQL 语句中。仅当问题与上一个问题不同时，您才需要打印该问题。有很多方法可以做到这一点。请记住，在 SQL 查询中，您需要执行以下操作：

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

确保同一问题的答案不会重复。然后执行类似以下操作（感谢@drrcknlsn 修复我在 php 上的尝试）：

$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"];
}