列出当天的星期和当天的事件（php，mysql）

Question

So, I have a page and I want to list all the days of the week and events on that day for a pub. Some of the days dont have events but i still want to list the day of the week. How should i set this up in my mysql database?

Answer 1

SELECT
    w.week_day
  , e.pub_id
  , e.event
FROM 
    weekday AS w
  LEFT JOIN 
    event AS e
      ON  e.day_of_week_number = w.week_number
      AND e.pub_id = @search_this_pub_id
ORDER BY 
    w.week_number