Customised Search

Discussion in 'Customization & add-ons' started by steve_19dozen, Nov 22, 2010.

  1. steve_19dozen

    steve_19dozen New Member

    Joined:
    Nov 16, 2010
    Messages:
    3
    Hi there,

    I am looking for a way for members to search through other members and pull out a list of each one (depending on location or something similar). The AMember install I am currently working on is for a business group who will want to be able to contact other members. Now I know this is possible, because the functionality is within the amember admin area already but when trying to pull information out using an SQL call, I noticed that all of the aditional field information is stored as serialized data.

    Can anyone give me a hint as to how to do this? Has it been done already? If Someone could just point me in the right direction, that would be great. I've never had to search through serialized data before.

    All the best,

    steve
  2. alexander

    alexander Administrator Staff Member

    Joined:
    Jan 8, 2003
    Messages:
    6,279
    Steve,
    Convert all additional fields from "common" to "SQL" This way you will be able to use SQL queries in order to search.

Share This Page