prepare(" SELECT c.certificate_code, comp.title as competition_title FROM certificates c JOIN submissions s ON c.submission_id = s.id JOIN competitions comp ON s.competition_id = comp.id WHERE s.user_id = ? "); $stmt->execute([$user_id]); $certificates = $stmt->fetchAll(); ?>