Here is my delema...I am designing/developing a site for a
event promotion company and I am kinda stuck as to what way to do
something. Actually 2 things. The 1st being the DB design. I have
done several dynamic sites before but never this involed. I am
using ASP and VBScript and access DB. Here is what I want to do.
Ok there are 4 events that all share basic traits. But things
like dates, times and rules will change from event to event. What
would the best structure be for the tables. 1 main table and then
look up tables that house the static info? Hope that this makes
sense.
2nd question how would I do this....all the events have race
classes that range from 50cc to pro. But due to turn out some of
the classes my not be offered at the events. So when editing the
event I would like to offer all the classes that are on by default
and the admin would have to uncheck the box to turn that class off
for that event so it doesn't display on the web page. I know that
this is going to have to be done dynamically but then that goes
back to the 1st question of setting up the DB
Hope all this makes sense...any help or tutorials would be
great..
thanks
B
2
Replies
AdChoices