Print horizontal table instead of vertical using PHP

Question

Problem:

I have a table that displays vertical values, but I would like it to print horizontal. 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 conclusion:

Answer 1

Scroll through the query results by first creating the two rows you need, and then add them to your table:

 $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> '; 

Answer 2

You can collect data in a two-dimensional array and later use this array to create output in different formats:

 $rows = array(); $index = 0; while ($row = mysql_fetch_assoc($result)) $rows[0][] = ++$index; $rows[1][] = $row['RID']; } $table = '<table class="table table-condensed table-bordered neutralize"> <tbody> <tr><td><b>Kriterium</b></td><td>%s</td></tr> <tr><td><b>Betyg</b></td><td>%s</td></tr> </tbody> </table>'; printf( $table, implode('</td><td>', $rows[0]), implode('</td><td>', $rows[1]) );