|
Russian version
|
List of Youth Decorated with the Honorable
Badges "Young Peacemaker", "Young Peacemaker-Instructor"
and "Peacemaker" in 1999–2005
if (($uid && !$logout) || $access) {
?>
function info ($num, $character) {
echo("");
if ($num > 0) {
if ($num > 1) {
$word = "entries";
} else {
$word = "entry";
}
echo("As whole $num $word");
if ($character) {
echo(" for letter "$character"");
}
echo(".");
} else {
echo("Not found!");
}
echo(" \n");
}
function format($text) {
if ($text) {
return "$text";
}
}
if(isset($character) || isset($search)) {
$connection = @mysql_connect($db_host, $db_user, $db_passwd);
@mysql_select_db($db_name, $connection);
if(isset($character)) {
$query = "SELECT * FROM young WHERE name LIKE '$character%' ORDER BY name";
} elseif(isset($search)) {
$query = "SELECT * FROM young WHERE $search_in LIKE '%$search%' ORDER BY name";
}
$result = @mysql_query($query);
@mysql_close($connection);
$num = @mysql_num_rows($result);
echo("\n\t ");
if($num == 0) {
print("Not found!");
} else {
info($num, $character); ?>
| Name |
Year of birth |
Organization |
Awarding date |
Comment |
while(($row = @mysql_fetch_array($result))) {
if ($search != "") {
if ($search_in == "name") {
$row['name'] = eregi_replace($search, "\\0", $row['name']);
} elseif ($search_in == "birth") {
$row['birth'] = eregi_replace($search, "\\0", $row['birth']);
} elseif ($search_in == "organization") {
$row['organization'] = eregi_replace($search, "\\0", $row['organization']);
} elseif ($search_in == "date") {
$row['date'] = eregi_replace($search, "\\0", $row['date']);
}
}
$row['date'] = ereg_replace("[\r\n]", " ", $row['date']);
$row['comment'] = ereg_replace("[\r\n]", " ", $row['comment']);
printf("\t\t
| %s |
%s |
%s |
%s |
%s |
\n", format($row['name']), format($row['birth']), format($row['organization']), format($row['date']), format($row['comment']));
}
print("\t\t
|
");
}
}
} else {
?>
}
echo("\n"); ?>
|