Database generated dropdown menu

[supernatural_247]

does anyone know of a script that I can get to function like this app:

http://www.projectorcentral.com/search.cfm
(Or choose a projector:)

When you choose an option in the drop-down, it takes you to it's related page.

I would also like a back-end admin to create the item value and its related review/specs page. I checked hotscripts, but I don't know what this would be classified as... tried news publishing, classified ads, etc. with no luck. any help is much appreciated!!

Thanks,
Tim

[webmasterjunkie]

Do you have any particulars on the language, php, asp, cfm? MySQL database right?

[supernatural_247]

Do you have any particulars on the language, php, asp, cfm? MySQL database right?

lol... can't believe I forgot that! Yes, I need it to be in English, PHP and MySQL. Thanks for asking!!

Cheers,
Tim

[ADAM Web Design]

The scripting language that performs the redirect isn't actually PHP. It's Javascript. Usually, when a form field change results in an immediate action without a submit button being pressed, it's Javascript.

In this case, this is the HTML/Javascript:

<SELECT NAME="part_id" ONCHANGE="submit()">

The onchange Javascript handler submits the form, which in turn retrieves the corresponding info from the form post and generates the page.

The back-end admin would really depend on what type of product it was, what information you wanted to show, the structure of the database, etc. There's about a million ways to handle this sort of thing, and I don't know of a generic script that will perform the task.