query("SELECT c.*, COUNT(p.id) as product_count FROM categories c LEFT JOIN products p ON c.id = p.category_id GROUP BY c.id"); $categories = $stmt->fetchAll(); ?>

Shop by Category

Browse our selection of boat parts by category

'fa-cogs', 'engines' => 'fa-ship', 'hull-parts' => 'fa-wrench', 'accessories' => 'fa-tools', 'electronics' => 'fa-satellite-dish' ]; foreach ($categories as $cat): ?>

Products