View Full Version : using html to access and filter a database?

10-04-2004, 10:04 PM
Hello, I'm new here as well as new to the task I am trying to achieve.

I have a database that I would like to be able to filter with drop down menus where the choices are the values in the columns. You could display the entire db, or if you filter it, you only see the records with the values you are using to filter. First of all, is this possible to do with just html? I have seen examples of this using Java Applets but was told it could be done easily with some html or javascript. I'm using Front Page now only because my employer hasn't gotten around to getting me Dreamweaver MX so I've been trying to look at it from a strictly code point of view and not through an editor.

I think I have to create a form, import the database into it, and create some drop down menus from the table. Is this correct? Am I biting off more than I can chew for a beginner?

Here's about as specific as I can be:
I have an Excel SS with about 2700 records (there will be more) where there are common numbers identifying records (i.e. #156 might identify more than one record and someone would want to filter it so only records with 156 show up). I have converted this to both an Access db and a mySQL db just because I wasn't sure what I would need to use. I've tried doing it through Front Page but I run into issues with the ODBC. Plus I don't have it published yet and I'm trying to make it before it gets published. (Is this possible?)

I'm sorry if this is too vague - I'm just not really able to say specifics about the information I'm working with. I hope what I'm asking makes sense. It's like I know what I need at the end - I'm just having a hard time getting started.

Thank you for any assistance!

10-04-2004, 10:55 PM
You need ASP or PHP or some serverside language to accomplish this.

Frontpage Database controls *STINK* and I do not recommend you put that verbose junk into your web pages. Plus, if memory serves the controls are so simplistic you can only display DB info.

If you are running IIS, then site has some helpful infomation on ASP and DB connections.