Heal Your Church WebSite


Teaching, rebuking, correcting & training in righteous web design.

Some time too much a good thing …

For the next 12 hours, I’m leaving this mistake up on the Events and Opportunities at Redland Baptist Church, Rockville Maryland page.

Can you guess what went wrong? Here’s a hint.

Yes, that’s me laughing at myself in the background.

* UPDATE * – okay, most of you caught the time stamp … one especially funny comment about not being able to ‘stomach our fellowship meal times’ [LOL]

Okay , now there’s one more error … or should I say ‘deficiency of excess‘ I need to address. Any takers? Solutions in SQL are acceptable.

* UPDATE *
Yup – a maximum date range might be nice. Not that we don’t want to tell people what we’re doing, but there is a concept at churches known as “too much information” … anyone who’s worked with you ministry will get it !-)

3 Comments

  1. So is the answer the fact that everything seems to occur at the crack of dawn?? heh Something wrong with your date conversions or date function?

  2. I sure wouldn’t go to your fellowship meal if it started at 5:45 in the morning. Call me lazy, but my bodies not quite ready for food then

  3. You can limit the display of events to those that occur in the next month or two by using a BETWEEN in your WHERE clause.

    SELECT date, title FROM events WHERE date BETWEEN NOW() And DATE_ADD(NOW(), INTERVAL 2 MONTH)

    I’d also suggest that you alter the display of your list somewhat. You have multiple events grouped under the same time (6:30 on Wednesdays for instance), but the titles are far enough away from the times to make it difficult for the eye to make the connection between them. It can be difficult for someone to tell if “Sanctuary choir” belongs to the 6:30 group or the 7:15 group.

    You could move the titles closer to the times. Or you could add a visual guide to help the eye connect the two. A small horizontal rule in a very light color would help without being intrusive. Or maybe leading dots connecting the time to the first item in the list (like you see in tables of contents).

    And completely off topic, the copyright on this page says 2002. The copyright on your church events page says 1997-2000. That’s not quite as bad as “last updated in June 2001 (http://www.healyourchurchwebsite.com/archives/000610.shtml),” but still.

    “You hypocrite, first take the plank out of your own eye, and then you will see clearly to remove the speck from your brother’s eye.” Matthew 7:5 (Sorry, I couldn’t resist. :) My site still says copyright 2002 as well. )