<?php
require 'config/db.php';
echo "BRANCHES:\n";
$stmt = $pdo->query("SELECT id, branch_name FROM tbl_branch LIMIT 10");
print_r($stmt->fetchAll(PDO::FETCH_ASSOC));

echo "\nBOOKING 32:\n";
$stmt = $pdo->prepare("SELECT b.id, b.pickup_point_id, p.branch_id FROM tbl_bookings b LEFT JOIN tbl_pickup_points p ON b.pickup_point_id = p.id WHERE b.id = 32");
$stmt->execute();
print_r($stmt->fetch(PDO::FETCH_ASSOC));
