Name: A Faggot 2010-09-07 19:48
Alright /prog/ - Working on a site for a client. Currently we have an event system up so that the owner (and eventually customers) can easily add events to the calendar for customers to see online. It is set up pretty simply with each event being an entry in a MySQL table currently set up like this:
id
filename (for images)
date
time
timeEnd
eventName
description
host
hostID
ip
--
That said, I was talking to the owner last night and she would like it so she could add tags to the events so that when people look at the calendar, they can filter it to see only relevant content.
Honestly, I don't see the reason for it as I doubt there are ever going to be that many simultaneous events. That said, I don't think I'm going to be able to convince her otherwise.
Right now I'm considering using a second table for each tag and linking it to the event ID. Then simply grab all the event ID's with a given tag when rendering the calendar. Any other thoughts on how I should implement this best? (I've never worked with creating a tagging system before)
id
filename (for images)
date
time
timeEnd
eventName
description
host
hostID
ip
--
That said, I was talking to the owner last night and she would like it so she could add tags to the events so that when people look at the calendar, they can filter it to see only relevant content.
Honestly, I don't see the reason for it as I doubt there are ever going to be that many simultaneous events. That said, I don't think I'm going to be able to convince her otherwise.
Right now I'm considering using a second table for each tag and linking it to the event ID. Then simply grab all the event ID's with a given tag when rendering the calendar. Any other thoughts on how I should implement this best? (I've never worked with creating a tagging system before)