Display results of MYSQL in PHP properly -

i'm building simple quiz php app , have sql query returns following results:

question_id | question_title | answer_title    1        |   name?   |   michael    1        |   name?   |   samuel    2        |   age?    |    20    2        |   age?    |    21    2        |   age?    |    23 

now want display each question answers in format this:

<div class="question">      <div>your name?</div>      <div class="answer">michael</div>      <div class="answer">samuel</div> </div>  <div class="question">      <div>your age?</div>      <div class="answer">20</div>      <div class="answer">21</div>      <div class="answer">22</div> </div> 

i'm using pdo display mysql results. problem if loop through mysql results, question displayed multiple times it's returned in each row. don't know how add closing div tag question class after answers question displayed.

thanks

what need group answers each question in multiple dimension array. try this:

$conn = new pdo($dsn, $user, $pass); $query = ''; // query run. $answers = array(); foreach ($conn->query($query) $row) {     $answers[$row['question_id']][] = $row['answer_title']; } 

then can foreach inside foreach:

foreach ($answers $question => $arr) {     echo '<tr><td>question: '.$question.'</td><td>answers: ';     foreach ($arr $i => $answer)     {         echo ($i > 0 ? ', ' : '').$answer;     }     echo '</td></tr>'; }