По странам:
$sql= "SELECT id, name_ru FROM COUNTRY";
$stmt = OCIParse($cursor, $sql);
OCIExecute($stmt);
while (OCIFetch($stmt))
{
$country_id = OCIResult($stmt, 1);
$name_ru = OCIResult($stmt, 2);
$sql2= "SELECT f_name, s_name, l_name, organization_, department, email,id FROM REGISTR where country_id=$country_id";
$stmt2 = OCIParse($cursor2, $sql2);
OCIExecute($stmt2);
if (OCIFetch($stmt2))
{
if ( $country_id==$country_id_selected) {
echo "
$name_ru ";
$sql2= "SELECT f_name, s_name, l_name, organization_, department, email,id FROM REGISTR where country_id=$country_id order by l_name";
$stmt2 = OCIParse($cursor2, $sql2);
OCIExecute($stmt2);
while (OCIFetch($stmt2))
{
$f_name = OCIResult($stmt2, 1);
$s_name = OCIResult($stmt2, 2);
$l_name = OCIResult($stmt2, 3);
$organization = OCIResult($stmt2, 4);
$department = OCIResult($stmt2, 5);
$email = OCIResult($stmt2, 6);
$id = OCIResult($stmt2, 7);
echo "
$l_name $f_name $s_name
$organization
$email ";
}
}
else echo "
$name_ru" ;
}
}
$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." участников";
?>