mysql - Printing out a table horizontal instead of vertical using PHP

Question

Problem:

I have a table that prints out vertical but I would like it to print horizontal instead. Anyone who can give guidance on how this can be achieved?

PHP code:

echo '
    <table class="table table-condensed table-bordered neutralize">     
        <tbody>
            <tr>
                <td><b>Kriterium</td>
                <td><b>Betyg</td>
            </tr>
';

while ($row = mysql_fetch_assoc($result))
{
    echo '
        <tr>
            <td>'.$i.'</td>
            <td>'.$row['RID'].'</td>
        </tr>
    ';

    $i++;
}

echo '
        </tbody>
    </table>
';

Current output:

Desired output:

Answer 1

Loop through your query results first building up the two rows that you want and then add them into your table afterwards:

$kriterium = '';
$betyg = '';

while ($row = mysql_fetch_assoc($result))
{
    $kriterium .= '<td>'.$i.'</td>';
    $betyg .= '<td>'.$row['RID'].'</td>';
    $i++;
}

echo '
    <table class="table table-condensed table-bordered neutralize">     
        <tbody>
            <tr>
                <td><b>Kriterium</td>'.$kriterium .'
            </tr>
            <tr>
                <td><b>Betyg</td>'.$betyg .'
            </tr>
        </tbody>
    </table>
';