All Pooled Requests
Create New Pool| Medicine | Status | Participants | Created By | Created On | |
|---|---|---|---|---|---|
| Pharmacies | View & Join |
prepare("SELECT * FROM users WHERE id = ?"); $stmt->execute([$userId]); $user = $stmt->fetch(); // Fetch all pooled requests $stmt = $pdo->prepare("SELECT pr.*, u.name as creator_name FROM pooled_requests pr JOIN users u ON pr.user_id = u.id ORDER BY pr.created_at DESC"); $stmt->execute(); $all_requests = $stmt->fetchAll(); ?>
| Medicine | Status | Participants | Created By | Created On | |
|---|---|---|---|---|---|
| Pharmacies | View & Join |