stryka
08-23-2002, 06:53 PM
Current Scenario: Existing website with DB backend... NT >> but converting to PHP/MySQL with vB...
My site lists 6 Festivals that are celebrated yearly and my users input events that are held surrounding each Festival. The input form asks them which if and which Festival it is associatied to (select from drop-down). Therefore, when my users go specifically to the Festival section they will see a listing of the associated events cuz the Festival is Foreign key within the event table... Only ADMIN that i need to do is to change the festival dates for each Year>
vB request: I don't know if it's an ADD-ON etc... but I have seen an event/calendar feature on most vBulletin boards... that allow you to input the date, event name (subject), and comments.... even possibly attach the flyer/poster... but I need to associate these events to each yearly festival...
However, how do I make an association with each event listing... cuz the Festival itself is an event but that means i have to create an input for the Festival every year but I can't make the relation if they are in the same DB... wouldn't I need an array or seperate DB?
What steps do you recommend ?
BONUS HACK QUESTION: I would like to further categorize each event... eg) boat cruise, cultural, rave etc... and each is identified with an icon...
So i guess the question is... Is it easy to add fields to the event posting, create further categories and associate them to other events/festivals found in another DB....
Thanx...
p.s. tell me if i make no sense...
My site lists 6 Festivals that are celebrated yearly and my users input events that are held surrounding each Festival. The input form asks them which if and which Festival it is associatied to (select from drop-down). Therefore, when my users go specifically to the Festival section they will see a listing of the associated events cuz the Festival is Foreign key within the event table... Only ADMIN that i need to do is to change the festival dates for each Year>
vB request: I don't know if it's an ADD-ON etc... but I have seen an event/calendar feature on most vBulletin boards... that allow you to input the date, event name (subject), and comments.... even possibly attach the flyer/poster... but I need to associate these events to each yearly festival...
However, how do I make an association with each event listing... cuz the Festival itself is an event but that means i have to create an input for the Festival every year but I can't make the relation if they are in the same DB... wouldn't I need an array or seperate DB?
What steps do you recommend ?
BONUS HACK QUESTION: I would like to further categorize each event... eg) boat cruise, cultural, rave etc... and each is identified with an icon...
So i guess the question is... Is it easy to add fields to the event posting, create further categories and associate them to other events/festivals found in another DB....
Thanx...
p.s. tell me if i make no sense...