Audio Sermons Database - How To....?

[AlanF]

Hello!

Let me cut to the chase - our church makes audio sermons available on our website and I am looking for some method of putting them in a database that will then be searchable or filterable by a number of different categories. I want to end up with something like this:

http://www.crichbaptist.org/sermonaudio.htm

These are some of our sermons or audio presentations which are hosted on SermonAudio.com, and can be streamed or downloaded. The above link is from our site and points to SermonAudio.com's site. However, we have many more that are not on there, and I would like to have some similar way of presenting all that we do have on http://www.crichbaptist.org.

Our web host (mediaserve.com) does provide for creating a database in its hosting packages (MySql) and also for PHP scripting, but I have no experience in either of these, and learning enough to create what I want would maybe prove too much of a learning curve for an old fogey like me

I have Googled the issue and CMS programs like Joomla and Drupal seem to be mentioned a lot, but I am not sure whether I could use either of these on my site which has been created using MS Frontpage, although I have now bought Expression Web 2.

Would I be able to use ether of these CMS programs and maybe create a sub-domain that would just contain the filterable sermons listing, and point to this page from within our existing site?

Or .. is there a better way?

Sorry to be so long-winded, but I await any replies with great interest.

AlanF

[developdaly]

Without much knowledge of PHP/MySQL you can still get away with using software that uses them....and you should.

My suggestion is to use WordPress and the WordPress Sermon Browser plugin.

You can use FrontPage or Expression to do whatever you want with the site.

You'll need to create a database (this just means using your hosts control panel to name a new database), then download Wordpress, upload it to your server and then go to the site -- it'll do the installation from there. Of course, read the more detailed instructions WordPress gives.

Start out on the subdomain. It's separate from everything else and will help you with a cleaner installation.

[waynehoskins]

Oh, there's a Sermon plugin for Wordpress? Cool.

I built my own PHP/MySQL system a few years ago for our site and then last month incorporated it into our new Wordpress site. It's pretty stinking simple. Using an off-the-shelf thing is probably better, but take a look at ours (http://www.crossroadsofarlington.org/sermons), and if you like I'll give you the PHP code and the database structure.

[LeAnn B]

Joomla + SermonSpeaker or the Bible Study component would do this for you.