I'm a noob when it comes to PHP and I'm wanting to do the following on a website using data in a MYSQL database:
Have an intial Form type box that asks for the type of service the user is after:
i.e. it reads specfic items from a column in the database called sname and autofills in the Drop down form.(note there are multiple entries for the same name in this column but would only like to see it once in the drop down list)
Once the selection is made the user can then narrow down the search using several more drop down form type boxes with the following names that are also autofilled depending on previous boxes selected.
Those other DB columns would be: scategory, scategorytype, scategorytype1, sregion, scity, ssuburb.
There would be one special form that would have multiple dollar amounts selectable and not from the DB but it would check the DB column scategorycost to see if the value falls within the selected amount.
i.e. options available in drop down form would be like the following : $0-$5, $6-10, $11-20 etc
The initial drop down box and the special drop down box would be the only two that would be compulsory wether the other drop down forms have selected data or not i'd like it to display certain fields to the user on the same page if possible.
i.e. db columns called sprovidername, sprovideraddress, sproviderurl and semail
Yeah well thats about it i spose..lol nice and easy...
Any help would be appreciated..
Happy New Year