使用表从mysql数据库显示数据

I have table of items and I want to display all the item in a table form. Each row must contain a maximum of 3 cells. How can I do that?

我有项目表,我想以表格形式显示所有项目。每行必须包含最多3个单元格。我怎样才能做到这一点?

$query = "SELECT * FROM newrequest";
    $result = mysql_query($query);

    echo "<table>

    <tr>";

    While($row = mysql_fetch_array($result))

    {    

            $query_two = "SELECT * FROM tblmember WHERE customer_id = '${row['customer_id']}'";
            $result_two = mysql_query($query_two);
            $username = mysql_fetch_array($result_two)['username'];


echo "

<td>               <p><b>Advertised by:</b> " .$username . " </p>

                  <img src= ".$row['location']." style= width:300px;   >

                  <p><b>Product name:</b>" .$row['product_name'] . "</p>

                  <p><b>Product price:</b>" . $row['price'] . "</p>


</td>";
}

echo "</tr>
</table>";


mysql_close();
?>

1 个解决方案

#1

<?php 
echo '<table>';

$i = 1;
while($row = mysql_fetch_array($result)) {

    $query_two = "SELECT * FROM tblmember WHERE customer_id = '${row['customer_id']}'";
    $result_two = mysql_query($query_two);
    $username = mysql_fetch_array($result_two)['username'];

    $flag = false;
    if($i%3 == 1) echo '<tr>';
    echo '<td>
                        <td><img src="'.$row['location'].'" style="width:300px;"/>
                        <p><b>Product name:</b>' .$row['product_name'] . '</p>
                        <p><b>Product price:</b>' . $row['price'] . '</p></td>
                      </td>';
    if($i%3 == 0) {
        $flag = true;
        echo '</tr>';
    }
$i++;
}
if(!$flag) echo '</tr>';
echo '</table>';

mysql_close();
?>