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 . '>'; }