"" || $_GET['d'] <> "" || $_GET['s'] <> "") {
$search = strtr($search, "áéíóú", "aeiou");
$sql = "SELECT crowname, engtrans, engname, district, state, descrip, addl FROM placenames WHERE 1=1";
if ($search <> "") {
$sql .= " AND (REPLACE(REPLACE(crowname, '&', ''), 'acute;', '') LIKE '%$search%' OR crowname LIKE '%$search%' OR engtrans LIKE '%$search%' OR engname LIKE '%$search%' OR district LIKE '%$search%' OR state LIKE '%$search%' OR descrip LIKE '%$search%' OR addl LIKE '%$search%')";
}
if ($_GET['d'] <> "") {
$sql .= " AND district LIKE '{$_GET['d']}'";
}
if ($_GET['s'] <> "") {
$sql .= " AND state LIKE '{$_GET['s']}'";
}
$sql .= " ORDER BY crowname";
$result = mysql_query($sql) or die(mysql_error());
}
if ($_GET['a'] <> "") {
$a = $_GET['a'];
$result = mysql_query("SELECT * FROM placenames WHERE crowname LIKE '$a%' ORDER BY crowname");
}
$districts = mysql_query ("SELECT DISTINCT district FROM placenames WHERE district <> '' ORDER BY district") or die(mysql_error());
$states = mysql_query ("SELECT DISTINCT state FROM placenames WHERE state <> '' ORDER BY state") or die(mysql_error());
?>
Faculty and students at Little Big Horn College have been compiling Crow place names and the narratives associated with them in an ongoing project that began in 1996. Over five hundred names have been recorded. The majority are within historic Crow Territory but some are as far away as central Alberta, Utah, Oklahoma and Washington, D.C.
You can search the database by entering an Apsáalooke or English place name or by initial letter of Apsáalooke name or by State or Reservation District.
"" && mysql_num_rows($result) == 0): ?>
No results found.
""): ?>
- Location: district, ""): ?> ()
- English literal translation:
""): ?>
- English name: “”
