使用PHP在三列html表中显示MySql表的三条记录

Question

I Need to show three records of MySql table in three different column using php.My Query is

SELECT * FROM TABLE1 WHERE Id IN(1,2,3)

I want to show the result as here

How can i Write LOOP for it?like

while(loop condition)
{
//what will go here?

}

UPDATE: First row fields will show in first column of html table and second record fields will display in second column and so on...I am not asking only show three records

Answer 1

OP saying, it's not so simple. But it is.

So, you have 2 ways to do it.

First. In this case, you are loop through on the 3 columns. Fetch the first row. This put all the data into a div. Class name is column_1. Do it for the other 3. Then floating the divs to left to each other.

$i = 1;
while($row = $db->fetch_row()) {
    ?>
<div class="column_<?php echo $i; ?>">
    <div class="picture">
        <?php echo $row["image"]; ?>
    </div>
    <div class="description">
        <?php echo $row["desc"]; ?>
    </div>
    ... and so on...

</div>
<?php
    $i++;
}

Second one, when you first collect the data about 3 rows, and then put them into a table rows by row.

<?php
    while($row = $db->fetch_row()) {
        $results[] = $row;
    }
?>
<table>
    <tr>
        <td><?php echo $result[0]['image'] ?></td>
        <td><?php echo $result[1]['image'] ?></td>
        <td><?php echo $result[2]['image'] ?></td>
    </tr>
    <tr>
        <td><?php echo $result[0]['desc'] ?></td>
        <td><?php echo $result[1]['desc'] ?></td>
        <td><?php echo $result[2]['desc'] ?></td>
    </tr>

</table>

EDIT

I forgot that, there is a third solution. You can just build the table empty, and then you can update the cells with an ajax call with jQuery.