Retrieve a pipe delimited string of autocomplete suggestions for profile categories
function profile_admin_settings_autocomplete($string) {
$matches = array();
$result = db_select('profile_field')
->fields('profile_field', array(
'category',
))
->condition('category', db_like($string) . '%', 'LIKE')
->range(0, 10)
->execute();
foreach ($result as $data) {
$matches[$data->category] = check_plain($data->category);
}
drupal_json_output($matches);
}