MakeButton("$nazwa_kontynent / $knazwa", 500);
BindStateHeader($panstwo);
$i = 0;
$sql = "SELECT COUNT(DISTINCT m.id) AS anz
FROM miasto AS m, jednostka AS j
WHERE m.panstwo_id = $panstwo
AND j.miasto_id = m.id";
$res = $DB_Base->QueryObject($sql);
$anzahl = $res->anz;
$sql = "SELECT DISTINCT m.nazwa , m.id
FROM miasto AS m, jednostka AS j
WHERE m.panstwo_id = $panstwo
AND j.miasto_id = m.id
ORDER BY m.nazwa";
$res = $DB_Base->Query($sql);
echo "
";
while ($r = mysql_fetch_object($res))
{
$i++;
echo "
";
$teiler = max(($anzahl/2), 15);
//echo "anz = $anzahl ::: teiler = $teiler ";
if ($i >= $teiler) { echo " | | "; $i = 0; };
};
echo " |
|
";
//******** tutaj jednostki pokazac w tym kraju *********************
echo "";
$i = 0;
$sql = "SELECT DISTINCT jt.id, jt.nazwa
FROM jednostkatyp AS jt, jednostka AS j, miasto AS m
WHERE jt.id = j.typ_id AND
j.miasto_id = m.id
AND m.panstwo_id = $panstwo
ORDER BY jt.nazwa ASC
";
$res = $DB_Base->Query($sql);
while ($r = mysql_fetch_object($res))
{
$i++;
echo "
";
};
echo " | ";
//******************************************************************
echo "
|
";
?>
|
|
include("frame_right.php");
?>
|