Hello I need 2 wordpress custom searches.
For search 1 (search on posts) :
I have a search box on my site (local right now so you cant see it) it uses both types of fields - custom and standard
Category drop down (with sub categories)
Custom fields are:
I would like the first search to use ALL of the fields to match before returning results. SO for example we have the following 3 records:
content='There are lots of black bees in the house'
content='The big bunny got loose in the house'
content='welcome to the frogs lair'
Example 1: If the user searches with the following:
category='The Bees\Sub Bee1'
Will only look in the category/sub category The Bees\Sub Bee1 - it will return that record because the term 'black' is listed in the content -
Example 2: If the user were to do the next search:
It would return records 1 AND 2 because of House being in both posts
Would return nothing because the keyword doesnt match the only record in the category funny\frog
Results should return to a standard wp search page and be linkable to the post results.
The second search needed is much easier:
Basically I have 4 custom profile fields in the wp_usermeta table:
They are organization_type, user_state, user_country, business_name
organization_type values are a,b,c,d (drop down)
user_state =normal states (drop down)
user_country=normal countries (drop down)
I want a search where I can say:
Give me a list of all the organizations of type a who are located in the country USA and in the state of Montana and make it a hyperlink to the users page (which should be author page I think)
- i would like the echo code to paste into my wordpress theme as well (so echo for each the results)
Im pretty sure this isnt to strange a request.