Dreamweaver/PHP

[nfr816]

Hi -

I want to be able to do is produce a list which is defined by specific
criteria. So, for example, I'd like a drop down box which contains the
following:

<select> ...
All
Company 1
Company 2
Company 3
... </select>

The user selects one of the options and the page is refreshed with the data.
So, for example:

"All" would call the query "select * from table"
"Company 1" would call the query "select * from table where company = 'Company
1'"
"Company 2" would call the query "select * from table where company = 'Company
2'"
"Company 3" would call the query "select * from table where company = 'Company
3'"

Instead of calling a new page I would like the target page to be the exisitng
page. Is this possible in DMX/PHP? Is there an extension?

Regards,

Neil.

[greg66]

Is this what you are looking for? There are Javascript versions, Google "chained selectors":

[url]http://www.zend.com/zend/tut/drop-down.php[/url]

Greg

[phillip baker]

i have a PHP form i dreamweaver i can get it to submit the information to a sql database but how do send the contacts to a email address

[nfr816]

Hi -

No. The effect that I want is the one produced by the form box at the top of
this forum which enables the user to switch the format in which the topic is
viewed between linear, threading, singluar, and branch. Only when the page is
first accessed I'd like a list to be produced from the SQL "select * from
table" and when the user selects the relevant option from the list, the page is
updated with the data returned from the relevant SQL, e.g.

List contains:
All
Red
Blue
Green

The first page would be the result of "select * from table". The "red" page
would be the result of "select * from table where color = 'red'". And so on.

Is this possible?

Regards,

Neil.