I have built a simple PHP calendar which displays a 12 month period. I have a MySQL database which holds calendar events. I would like to populate my calendar with my events. I could of course run a MySQL query for each day but 365 queries seems very inefficient, as does running a single MySQL query and looping through the results 365 times. What, if any, are the alternatives? Is there a simple, and efficient, way of doing this?