Hi Randy
I created a content type, and this search is created under that.
thanks for response. I believe I sorted number one above out, but still struggle to understand how to do number 2.
My structure is like this. parent category - > provinces categories -> towns categories -> listings of directory content type
If you can explain to me how to write FREE queries, and how to plugin the values of fields in the search form into those queries, then it will help me greatly. I can do this kind of things easily with some js, mysql and php, but I am not sure what is the actual syntax used by SEBLOD to write free queries.
In the case of a generic search, where I would also like people to search for the town name or province name, I would normally have to join the $__categories id , parent_id and title somewhere on the $__content catid to get the names of categories so I can filter results based on those.
I also have another search where I want to have a province dropdown and a property type dropdown. The first list will be populated by getting all the categories with a certain parent_id which would be the id of the overall directory. Then the user chooses a province, and then the system must quickly run a query and find all the titles and ids for the categories that have the parent_id of the selected province. From that list, all the returned values must be used to construct the final query where listings will be filtered by catid inside the $__content table. Something like (catid = 99) OR (catid = 100) OR (catid = 101)
So to sum it all up:
HOW do I write custom queries for Search Generic, or CCK field or any other field in SEBLOD. Specifically, how to I plug values in from the fields in the actual search form. (in php I would grab the $_GET['field_name'] and use that in my code that writes the query before running it on the db. )
How to do this in SEBLOD? If you can give an example or two, or point me to some documentation of the correct syntax I would greatly appreciate it.
Thanks.
SEBLOD rocks so far, it's just that I get stuck with things like this and would want to move on