Definition
profile_autocomplete($field, $string)
profile/profile.module, line 710
Description
Callback to allow autocomplete of profile text fields.
Code
<?php
function profile_autocomplete($field, $string) {
if (db_result(db_query("SELECT COUNT(*) FROM {profile_fields} WHERE fid = %d AND autocomplete = 1", $field))) {
$matches = array();
$result = db_query_range("SELECT value FROM {profile_values} WHERE fid = %d AND LOWER(value) LIKE LOWER('%s%%') GROUP BY value ORDER BY value ASC", $field, $string, 0, 10);
while ($data = db_fetch_object($result)) {
$matches[$data->value] = check_plain($data->value);
}
print drupal_to_js($matches);
}
exit();
}
?>