I intergrate my dbman with the links manager..

I have a field called Category.. and it enters into the database like this...

lCounty/Town/Property_Typel

for example..

lSussex/Brighton/1Bed_Apartmentsl

lSussex/Brighton/2Bed_Apartmentsl

I need two dropdown select fields to search the same Data Field..

ie... >County/Town< and the other dropdown menu >PropertyType<..

so if some1 makes a search the results will only show for example..

Sussex/Brighton and 1Bed Apartments..

Not too sure about how to go about this..

thanxs in advance.. Justin

Pleaze......... anyone............. I´m stuck............

Thanxs.....

It is not so diffecult to make a drop down list from a field, there is a sub built-in to db.cgi fro that. The problem is that you have 3 fields (or 2) inside one field.

I recommend you start by getting the drop down to display the entire field, then start hacking around to get the field split into 2 or 3 fields as needed.

Look at this post for the first part, then let us know how it's going and I can see if I can help on the second part.

http://www.gossamer-threads.com/...i?post=245158#245158

Thanxs for the reply..

I use the "sub build_fancy_select_field" to generate the dropdown lists..

But im just really not sure how to split these into two seperate dropdowns and search the single fields.. I have read the thread provided.. but still no joy.. to be honest.. not even sure where to start with it..



I attach a copy of my html.pl http://www.visaverde.com/html.txt



Thank justin..