显示mysql数据库中的所有项目

Question

I have table product and table category in my database. I want to display all category dynamically in a table and inside the table of each category I am displaying all item belonged to that category too.

Those categories and items should be displayed like this :

And here is my coding to do the work :

$fetch_cat = "SELECT * FROM tblcat"; //fetch from table category
$result = $conn->query($fetch_cat);
if ($result->num_rows > 0)
{
    while($cat_row = mysqli_fetch_assoc($result))
    {
        $cat_title = $cat_row['catName'];
        echo '<table>';
        echo '<tr>';
        echo '<td><img src="category/'.$cat_row['catImg'].'" /></td>';
        echo '<td>';
        echo '<ul class="content_init">';

        $stmt = "SELECT * FROM tblproduct WHERE prodCat = '".addslashes($cat_title)."' LIMIT 4"; //fetch from table product
        $result = $conn->query($stmt);
        if ($result->num_rows > 0)
        {
            while($row = mysqli_fetch_assoc($result))
            {
                echo '<li>';
                echo '<a href="#"><img style="height: 188px; width: 188px;" src="user_images/'.$row['prodImg'].'" />';
                echo '<br /><br />';
                echo '<h4>'.$row['prodName'].'</h4>';
                echo '<label><span>RM </span>'.$row['prodPrice'].'</label></a>';
                echo '</li>';
            }
        }

        echo '</ul>';
        echo '</td>';
        echo '</tr>';
        echo '</table>';
    }
}

Problem :

So the problem with my coding is, it can only display Category 1 with items belonged to it. The rest categories unable to be displayed. I guess my coding might not loop properly because of bad programming as it unable to display the expected output.

Answer 1

The $result variable was reused by the inner query thus the first result override.

Change the variable name either of the $result variable.