Using php to echo mysql query results in a tabular form

Question

I have a small shopping cart I am writing, and currently am facing problems on how to display MySQL table results into a tabulated display. I have a code that does the whole database search and returns results, my problem is displaying the results like most shopping carts do.

Here is an example of what I would like to achieve.

<table>

<tr>
<td>First mysql result row comes here</td>
<td>Second Mysql result row comes here</td>
</tr>


<tr>
<td>third mysql result row comes here</td>
<td>fourth Mysql result row comes here</td>
</tr>

</table>

Note that it displays two <td> per line.

I am having a tough time trying to find this out. Could it be done using css?

JJJ · Accepted Answer · 2012-06-01 21:11:39Z

3

<table>
<?php
$tr = false;

foreach( $results_from_database as $result ) {
    $tr = !$tr;

    if( $tr ) {
        echo '<tr>';
    }

    echo "<td>$result</td>";

    if( !$tr ) {
        echo '</tr>';
    }
}

// if there's odd amount of results, add an empty cell and close the tr tag
if( $tr ) {
    echo '<td></td></tr>';
}
?>
</table>

answered Jun 1, 2012 at 21:11

JJJ

33.2k20 gold badges95 silver badges103 bronze badges

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

1 Comment

JJJ Over a year ago

Well, yes, I used just a placeholder. You're supposed to replace it with the actual loop you use to go through the query results.

Collectives™ on Stack Overflow

Using php to echo mysql query results in a tabular form

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related