Foo - Webpage code gurus: Developing a simple, process-of-elimination database (bike ID)

Bikeforums.net is a forum about nothing but bikes. Our community can help you find information about hard-to-find and localized information like bicycle tours, specialties like where in your area to have your recumbent bike serviced, or what are the best bicycle tires and seats for the activities you use your bike for.




cudak888
08-22-10, 12:24 PM
I'm trying to come up with a simple code to mimic something - such as Identifont's process-of-elimination font identifier - for positively identifying older Raleigh Sports framesets:

http://www.identifont.com/identify.html

I don't care whether I use Javascript/PHP/SQL or some form of DHTML combo - all I want is something reliable, quick, and reasonably orderly to work with if I wish to add additional data points.

I intend to have the final destination of such a search to be one of my preexisting .HTML pages - i.e., I don't need the last page result to be dynamic.

I realize I could accomplish this same result with half a dozen different .HTML pages, but that doesn't seem to make much sense when other dynamic coding systems already exist to make the process much easier.

That said, I've been scouring the internet trying to find references to a suitable system, but I've come up with nil, so far - I don't know what this specific form of code would be called. I've found drop down lists, and a few other oddball methods, but nothing quite the same as what I'm seeking.

Any ideas?

-Kurt


bigbenaugust
08-22-10, 01:58 PM
It's all about phrasing your SQL correctly.

If it's a process of elimiation, then you want to SELECT all records FROM some table WHERE something does NOT exist.

Pre-built? I don't know. But it could be done.

cudak888
08-22-10, 09:13 PM
As I thought.

Unfortunately, I took the not-so-quick-but-very-dirty method and ran with it:

Raleigh Sports Interactive ID System (http://jaysmarine.com/TH_sports_selfID.html)

Seems to work without a hitch (with exception to the pages of which I have not created yet). I do have the ability to add quite a bit of additional information to each separate page though - when dealing with the Sports, that's a plus.

-Kurt