SQL Query Explanation
User
$query = "SELECT o.*, e.event_name, e.event_venue, e.event_datetime, e.event_date_id
FROM orders o
JOIN events e ON o.event_id = e.event_id
WHERE o.order_code = ? AND o.event_id = ?";
what above query will do
FROM orders o
JOIN events e ON o.event_id = e.event_id
WHERE o.order_code = ? AND o.event_id = ?";
what above query will do