creating database

Do you have a question? Post it now! No Registration Necessary.  Now with pictures!

Threaded View
I'm hoping to create a database for a particular group of professionals
in the UK and Ireland (and possibly Europe) so that visitors to my site
(not the one below, though that might benefit from a similar system) can
easily search and find either one who is near them geographically, or
who provides the kind of service they need.

The professionals will be invited to sign up to be listed.

I'm wondering before I begin what's the best way to set it up. A-Z by
name, geographic location (county or city). A page per person or a list
of people grouped either by surname first letter or location.

And then there's the question of hiding email addresses. I understand
that the only safe way to protect these from spambots is not to include
them at all, but I've also heard using a non-live graphic is safe to a
degree. If possible I'll direct visitors to the professional's webpage

I imagine there'll be a maximum of 500-800 on the database, so some way
of automating part of the process would be useful.

Any thoughts or suggestions?
Eating out in London? Read my tips...

Re: creating database

Quoted text here. Click to load it

I would say all three would be the way to go, so that users have a
choice.  If the user doesn't know the name, they should be able browse
categories, or browse by location, search by keyword, or browse

Quoted text here. Click to load it

You could ask the member if they want to reveal their address, and if
so, you could display the email address, otherwise, you could set it up
so your system emails the member with the message from the user, ala

Quoted text here. Click to load it

Seriously, hire someone with relational database and server side

Adrienne Boswell at Home
Arbpen Web Site Design Services
Please respond to the group so others can share

Re: creating database

Quoted text here. Click to load it

Thanks for your input Adrienne. I've thought about it more and come to
the same conclusion. I've already contacted an ex-colleague who
specialises in this kind of work. Not sure how far I'll get on my
virtually non-existent budget, though.
Eating out in London? Read my tips...

Site Timeline