HTML table not displaying with a php while loop inside of it

Question

I am creating a table that loops information from my database. I created the table with html and added styling via an external css sheet. The table format is not displaying in any way. None of the borders are displaying and the 100% width is not working. Could my while loop be causing this affect?

<table class="tableproduct">
                        <tr>
                            <th class="thproduct">Product ID</th>
                            <th class="thproduct">Product Name</th>
                            <th class="thproduct">Price</th>
                            <th class="thproduct">Category</th>
                            <th class="thproduct">Description</th>
                        </tr>   
 <?php                  
    while($row = mysqli_fetch_assoc($q)) : ?>

                        <tr>
                            <td class="tdproduct"><?php echo $row['product_id']; ?> </td>
                            <td class="tdproduct"><?php echo $row['name']; ?> </td> 
                            <td class="tdproduct"><?php echo $row['price']; ?> </td>
                            <td class="tdproduct"><?php echo $row['category']; ?> </td>
                            <td class="tdproduct"><?php echo $row['description']; ?> </td>
                        </tr>
                    </table>    
<?php   endwhile; ?>


.tableproduct {
width: 100%;
border: 1px solid black;
}
.tdproduct {
    border: 1px solid black;
}
.thproduct {
    height: 100px;
    border: 1px solid black;
}

I fixed it. The php didn't space right, causing it to appear as a gap in between the table code when the code was originally posted. — user4566987
– user4566987, Commented Apr 12, 2015 at 7:16

user4566987 · Accepted Answer · 2015-05-03 07:34:18Z

1

I ended up resolving this.

I had to put an if statement with the while loops and it created the results I was looking for.

I added this to the while loop:

if( $result ){  
    while($row = mysqli_fetch_assoc($result)) :

answered May 3, 2015 at 7:34

user4566987

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

Collectives™ on Stack Overflow

HTML table not displaying with a php while loop inside of it

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related