По алфавиту:
if ($letter=='А') echo "
А "; else echo "
А ";?>
if ($letter=='Б') echo "
Б "; else echo "
Б ";?>
if ($letter=='В') echo "
В "; else echo "
В ";?>
if ($letter=='Г') echo "
Г "; else echo "
Г ";?>
if ($letter=='Д') echo "
Д "; else echo "
Д ";?>
if ($letter=='Е') echo "
Е "; else echo "
Е ";?>
if ($letter=='Ж') echo "
Ж "; else echo "
Ж ";?>
if ($letter=='З') echo "
З "; else echo "
З ";?>
if ($letter=='И') echo "
И "; else echo "
И ";?>
if ($letter=='К') echo "
К "; else echo "
К ";?>
if ($letter=='Л') echo "
Л "; else echo "
Л ";?>
if ($letter=='М') echo "
М "; else echo "
М ";?>
if ($letter=='Н') echo "
Н "; else echo "
Н ";?>
if ($letter=='О') echo "
О "; else echo "
О ";?>
if ($letter=='П') echo "
П "; else echo "
П ";?>
if ($letter=='Р') echo "
Р "; else echo "
Р ";?>
if ($letter=='С') echo "
С "; else echo "
С ";?>
if ($letter=='Т') echo "
Т "; else echo "
Т ";?>
if ($letter=='У') echo "
У "; else echo "
У ";?>
if ($letter=='Ф') echo "
Ф "; else echo "
Ф ";?>
if ($letter=='Х') echo "
Х "; else echo "
Х ";?>
if ($letter=='Ц') echo "
Ц "; else echo "
Ц ";?>
if ($letter=='Ч') echo "
Ч "; else echo "
Ч ";?>
if ($letter=='Ш') echo "
Ш "; else echo "
Ш ";?>
if ($letter=='Щ') echo "
Щ "; else echo "
Щ ";?>
if ($letter=='Э') echo "
Э "; else echo "
Э ";?>
if ($letter=='Ю') echo "
Ю "; else echo "
Ю ";?>
if ($letter=='Я') echo "
Я "; else echo "
Я ";?>
$sql= "SELECT f_name, s_name, l_name, organization_, department, email FROM REGISTR order by l_name";
$stmt = OCIParse($cursor, $sql);
OCIExecute($stmt);
while (OCIFetch($stmt))
{
$f_name = OCIResult($stmt, 1);
$s_name = OCIResult($stmt, 2);
$l_name = OCIResult($stmt, 3);
$organization = OCIResult($stmt, 4);
$department = OCIResult($stmt, 5);
$email = OCIResult($stmt, 6);
$l_name_letter=substr($l_name,0,1);
if ($l_name_letter==$letter)
{
echo "
$l_name $f_name $s_name
$organization,
$email ";
}
}
$sql= "SELECT count(id) FROM REGISTR";
$stmt = OCIParse($cursor, $sql);
OCIExecute($stmt);
OCIFetch($stmt);
$count = OCIResult($stmt, 1);
$count_last=substr($count,strlen($count)-1,strlen($count));
if (($count_last==2)or($count_last==3)or($count_last==4))
$count_text=$count." участника";
elseif ($count_last==1)
$count_text=$count." участник";
else $count_text=$count." участников";
?>