halohalo

<?php $conn = mysqli_connect('localhost', 'root', '', 'stanjo'); $res = mysqli_query($conn, 'SELECT category_id, COUNT(*) as total FROM products GROUP BY category_id'); while($row = mysqli_fetch_assoc($res)) { echo "Category ID " . $row['category_id'] . ": " . $row['total'] . " products\n"; } $unassigned = mysqli_query($conn, 'SELECT id, title FROM products WHERE category_id IS NULL OR category_id = 0'); while($row = mysqli_fetch_assoc($unassigned)) { echo "Unassigned: " . $row['id'] . " - " . $row['title'] . "\n"; } ?>