private static function lookupPlaceDB($conn, $abbrev)
{
$abbrev = mysql_real_escape_string($abbrev, $conn);
$sql = "SELECT name, title FROM place_abbrevs WHERE abbrev LIKE '{$abbrev}%' ORDER BY priority LIMIT 32";
$res = @mysql_query($sql, $conn);
if ($res === false) {
return false;
}
$results = array();
while ($row = mysql_fetch_array($res, MYSQL_NUM)) {
$name = $row[0];
$title = $row[1];
// has this name-title combination already been found?
$found = false;
foreach ($results as $result) {
if ($result['name'] == $name && $result['title'] == $title) {
$found = true;
break;
}
}
if (!$found) {
$results[] = array('name' => $name, 'title' => $title);
if (count($results) == 8) {
break;
}
}
}
$xml = '';
foreach ($results as $result) {
$xml .= '<result><name>' . AutoCompleter::escape($result['name']) . '</name><title>' . AutoCompleter::escape($result['title']) . '</title></result>';
}
$status = 'success';
return '<' . AutoCompleter::RESULTS_TAG . " status=\"{$status}\">\n" . $xml . '</' . AutoCompleter::RESULTS_TAG . '>';
}
