Thread

I am wondering what the best approach would be to creating a member search form.

I would like to create a form that enables someone to search for a member based on various custom profile field data including age.

I would like for the form to have “age-from” and “age-to” select boxes. So you would be able to select from 22 to 28 for example and this would return members who are either those ages or between those ages. But it would return only the members who are either those ages or between those ages who also match the other criteria in the search form.

I see that expressionengine does store bday_y, bday_d and bday_m in the exp_members table.

So I’m basically wondering what approach would be best and if anyone can offer any tips or point me in the right direction etc to achieve this. Like, for example, would the query module along with some php be a good approach to creating a custom search form and would I use the birthday fields already in EE or need to find some sort of alternative way?

Thanks for your help in advance! I look forward to hearing any responses! 😊

Hi Bamboozle Man,

I think Solspace Super Search might be able to do what you’re after (I know it works with ranges). http://www.solspace.com/software/detail/super_search/
It’s a little pricey but would be the way to go I think unless you were up for getting into some PHP and SQl custom query magic.