Query("SELECT * FROM $tPeople WHERE UPPER(name) LIKE '$fL%' ORDER BY name");
else {
$dPeople=$dbMain->Query("SELECT * FROM $tPeople WHERE name<'А' OR name>'Я' ORDER BY name ASC LIMIT $cRecsPerPage");
if ($dPeople->NumRows()<=1) $dPeople->Query("SELECT * FROM $tPeople ORDER BY name LIMIT $cRecsPerPage");
}
}
else $dPeople=$dbMain->Query("SELECT * FROM $tPeople WHERE id=$id");
if (!$id) {
echo "";
for ($i=0;$i<$dPeople->NumRows();$i++) {
$dPeople->NextResult();
$p_id = $dPeople->Get("id");
$sqlCount = "SELECT COUNT(*) FROM $tMain WHERE visible='true' AND participants_ids LIKE '% $p_id %'";
$resCount = mysql_query($sqlCount);
if (mysql_result($resCount, 0, 0) == 0){
//echo "
No: ".$p_id."
";
continue;
}
$xDat=MakeDate($dPeople->Get("bdate"), $dPeople->Get("ddate"));
$xTitle=$dPeople->Get("name");
if (trim($xTitle)) echo "- ".($xDat?"$xDat | ":"")."Get("id").">".$xTitle."";
}
echo "
";
} else {
$dPeople->NextResult();
$xName=$dPeople->Get("name");
$xDat=MakeDate($dPeople->Get("bdate"), $dPeople->Get("ddate"));
echo "".$xName.($xDat?" ($xDat)":"")."
";
echo nl2br(trim($dPeople->Get("description")));
$fL=substr($xName,0,1);
$dPeople->Query("SELECT * FROM $tMain WHERE visible='true' AND participants_ids LIKE '% $id %' ORDER BY dat ASC");
echo "";
}
echo "
";
LetterPages("fL",$fL);
echo "
";
foot();
?>