Display from array only once

Question

Im using the following code. It goes through a DB and pulls out the question and the related answers.

However it displays the question each time it prints an answer.

How can I make it so the question is only printed once and then the answers are printed.

$qna = mysqli_query($conn, "SELECT q.QText, a.id, a.AText FROM question q INNER JOIN answer a ON q.id = a.Question_ID WHERE q.id=1")  or die(mysqli_error($conn));

while ($data2 = mysqli_fetch_array($qna)) {

echo '<td>'.$data2['QText'].'</td>';

echo '

<table class="layout display responsive-table">
        <thead>
            <tr>
                <th>ID</th>
                <th>Answer</th>
            </tr>
        </thead>
    <tr>
    <td>'.$data2['id'].'</td>
    <td>'.$data['AText'].'</td>
    <td>'.$data['Group_ID'].'</td>
    </table>

';

  }

Just remove LOOP (WHILE) and make it $data2 = mysqli_fetch_array($qna) — Mulham Aryan
– Mulham Aryan, Commented Feb 13, 2016 at 11:33

Dan Charousek · Accepted Answer · 2016-02-13 11:53:22Z

1

Select an ID from question table aswell like:

SELECT q.QText, q.id AS QId, a.id, a.AText FROM ...

And then you can print out the question only once using condition:

$lastQuestionID = 0;
while ($data2 = mysqli_fetch_array($qna)) {

if($data2['QId'] != $lastQuestionID)
    echo '<td>'.$data2['QText'].'</td>';

$lastQuestionID = $data2['QId'];

// printing answer here

}

answered Feb 13, 2016 at 11:53

Dan Charousek

3223 silver badges9 bronze badges

Sign up to request clarification or add additional context in comments.

4 Comments

Dan Charousek Over a year ago

Notice that the condition should only apply on QText echoing, be sure you didn't wrap printing answer aswell.

JohnyChew Over a year ago

my bad , i had a group by bit (experimenting). However it wont print out the AText bit

JohnyChew Over a year ago

Iv checked the field is called AText in the DB . It shoudlnt matter that its a varchar

JohnyChew Over a year ago

Hey I found a problem . for me it prints the first question , then the second and then the answers to the first so its always a question behind

Collectives™ on Stack Overflow

Display from array only once

1 Answer 1

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related