creating a table in mysql for events
<p>I need to create a data base of star gazing events that can be queried by the user entering their location and the date to get results,
The idea is that certain constellations can only be seen in northern hemisphere towns on certain months, I think I can connect them by having a table of events with hemisphere field and a months_viewable field. Also a locations table with a hemisphere field that can link with the events table. 
I am currently planing the following tables, </p>

<pre><code> event table ( event id, event_name, event_type, event_description,       event_month, hemisphere )

 Location table ( local_id, city, country, hemisphere )
</code></pre>

<p>this would need the event_month field to hold multiple months, is this possible or is there a more suitable way to complete this?
I thought if this would work I could simply then query it using a query like</p>

<pre><code>SELECT *
FROM event inner join location
on event.event.hemispher = location.hemispher
WHERE city LIKE (city entered)
AND month LIKE (month entered)
</code></pre>