Forum Moderators: phranque

Message Too Old, No Replies

Searching a Database

         

zulufox

5:42 am on Jan 31, 2004 (gmt 0)

10+ Year Member



I'm looking for a way to duplicate this proccess avalible on:

volunteerabroad (dot) com/search.cfm

I would like users to be able to search a database or specific entries in the database for predefined keyboards.

Therefore a user could select, “4-8 weeks”, “Africa”, and “Medical” and it would bring back all the selections that fit these categories, from which the user could read more about the specific volunteer opportunities.

What Id love to see is a CMS that did this, but ill settle for ANY way to do this.

Has anyone seen any scripts or anything?

It can be in ASP or PHP. This is a key section of my site and im dying trying to figure out how to do it.

James in Vancouver

7:01 am on Jan 31, 2004 (gmt 0)

10+ Year Member




A simple lookup like that is pretty easy to do. You could program it in PHP with a MYSQL database quite easily. I have done numerous much more complicated type of systems.

It should take someone who is knowledgeable in this only a few hours to create the form submission to for the limits, Database lookup and the procedure to print it.

If I was you I would try not just to duplicate that process, but come up with ways of making it better. I don't think that system you gave as an example is particularly user friendly. The main problem is that the drop down lists are way to long, but I think it could be improved in other ways as well. Some of the improvements might mean having a dfferent organization for the database.

If you have a little bit of time and any knowledge of programming (or are willing to learn), I would recommend reading up about php and mysql and try to do it yourself, it is really quite easy. Doing it yourself will also open your eyes to what is possible, which may give you whole new ideas on where to go.

James