How can I best re-design this site?

  • Thread starter Thread starter John Patrick
  • Start date Start date
J

John Patrick

Here's my existing website, built using FP2002:

http://www.motorcityrock.com/

Basically, the site consists of a large library of bands, musicians, and
venues. Each band has it's own listing that includes the band's members, a
timeline of gigs performed, and a variety of links to pages with related
information including photos, MP3's, etc.

Every time I add a new band, I have to add the information to several pages
because everything is cross-linked. Very time-consuming with over 400 bands
and 900 individual pages!

So, I'm thinking of re-designing the site with some sort of a database that
will allow me to store the musicians, bands, venues, and all related
memorabilia. That way I just add the bands name, band members, and gigs
played once and it will display on all applicable pages in nice tables.

What should I use (along with Frontpage) to build this? Access? SQL? ASP?

Thanks!

jp
 
-----Original Message-----
Here's my existing website, built using FP2002:

http://www.motorcityrock.com/

Basically, the site consists of a large library of bands, musicians, and
venues. Each band has it's own listing that includes the band's members, a
timeline of gigs performed, and a variety of links to pages with related
information including photos, MP3's, etc.

Every time I add a new band, I have to add the information to several pages
because everything is cross-linked. Very time-consuming with over 400 bands
and 900 individual pages!

So, I'm thinking of re-designing the site with some sort of a database that
will allow me to store the musicians, bands, venues, and all related
memorabilia. That way I just add the bands name, band members, and gigs
played once and it will display on all applicable pages in nice tables.

What should I use (along with Frontpage) to build this? Access? SQL? ASP?

Thanks!

jp

when you create websites make it simple!
.
Click to expand...
 
Hi John,

You have the right idea there. Let me point you to a few articles I wrote
for MSDN that deal specifically with building database-driven web
applications using FrontPage:

http://msdn.microsoft.com/library/en-us/dnfp2k2/html/fp_autowkdb.asp?frame=true
http://msdn.microsoft.com/library/en-us/dnfp2k2/html/fp_autowithdynamiccontent.asp?frame=true
http://msdn.microsoft.com/library/en-us/dnfp2k2/html/odc_fpbestasppractices.asp?frame=true

Good luck with your endeavor!

--
HTH,

Kevin Spencer
Microsoft MVP
..Net Developer
http://www.takempis.com
Big Things are made up of
Lots of Little Things.
 
Back
Top