Cities: ".$numr." ";
$sum1=0;
for($i=0; $i<$numr; $i++)
{
echo " ";
$what_city=mysql_result($res,$i,"city_en");
$sity_code=urlencode($what_city);
echo "$what_city";
echo " (".mysql_result($res,$i,"sum1").")"; // number of sites in city
$sum1=$sum1+1;
if ($sum1==4) {echo " "; $sum1=0;} // devide city onto 4 names in each line
}
echo " "."Sites: ".$numr3."
";
// category extracting
// how many type of categoris in base
$query5 = "SELECT categor_en ,count(*) as sum2 from uarailway group by categor_en order by sum2 desc";
$res5 = mysql_query($query5);
$numr5=mysql_numrows($res5);
echo "Categories: ".$numr5." ";
$sum1=0;
for($i=0; $i<$numr5; $i++)
{
echo " ";
$what_cat=mysql_result($res5,$i,"categor_en");
$category_code=urlencode($what_cat);
echo "$what_cat"." (".mysql_result($res5,$i,"sum2").")"; // number of sites in city
$sum2=$sum2+1;
if ($sum2==4) {echo " "; $sum2=0;} // devide city onto 4 names in each line
}
echo "
";
?>
