Dreamweaver MX / MySQL / PHP
I'm currently working on a DYNAMIC DROPDOWN SEARCH for a
recruitment company Where the visitor selects either "ANNUAL" or
"HOURLY" in the first menu and the second menu changes to either
£10,000 0r £4.50 for the wages section.
I can make the second menu change dynamically after the first
menu is defined, but the ID given to the second menu (by me) means
that it only ever searches the Hourly field or the Annual field but
not both. Let me explain...
I have a Jobs table and a salary table. Two fields in the
Jobs table are HOUR and ANNUAL and these are inserted using a menu
list drawn from a salary table. Its very easy to insert the data
into the Jobs table - click on the HOURLY menu, select the figure
and insert it into the HOUR field and then complete the process by
inserting the relevant figure into the ANNUAL field. The problem
lies in a customer search on the Public side,
I want the visitor to choose either HOUR or ANNUAL when
searching. I can do this using a dynamic dropdown menu (an MX
Extension) THE FIRST MENU is selected and then the second menu
changes to either the Annual or Hourly figures. BUT!!! I can only
give one ID to the second menu which is.....
S_jobHourly or S_jobAnnually
So it works to a degree - if I make the second menu's ID
value S_jobHourly it will return all the hourly figures chosen by
the user. But if the user clicks ANNUALLY then it returns nothing
because there are no hourly rates = £10,000.
Is there a way to perhaps join these two fields in a
recordset and then give that join a new name? So I could say name
the result S_jobSum and that means that the second dropdown menu
(given the value S_jobSum) would search both £10,000 and
£4.50 and then return the Job which matches?
Hope this is clear.
I'm really close on this and any help on this would be
absolutely fantastic.
Many thanks
Hurst
1
Reply
AdChoices