\n";
#tisk ulic
echo "Ulice : ";
$dotaz=MySQL_Query("SELECT DISTINCT ulice from adresy ORDER BY ulice,cp,byt");
$count=MySQL_Num_Rows($dotaz);
$count++;
for ($i=1;$i<$count;$i++)
{
$radek=MySQL_Fetch_Array($dotaz);
echo "
".$radek["ulice"].' * ';
echo '
';
}
#dotisk posledni volby pro vsechny ulice
echo "
v�echno";
echo '
';
echo "
";
#tisk cisel popisnych
echo "�.p. : ";
if($ulice=="vsechno") {
$wherecp = "";
} else {
$wherecp="WHERE ulice = \"$ulice\"";
}
$dotaz=MySQL_Query("SELECT DISTINCT cp from adresy $wherecp ORDER BY cp");
$count=MySQL_Num_Rows($dotaz);
$count++;
for ($i=1;$i<$count;$i++)
{
$radek=MySQL_Fetch_Array($dotaz);
echo "
".$radek["cp"].' * ';
echo '
';
}
#dotisk posledni volby pro vsechna cp
echo "
v�echno";
echo '
';
echo "
";
echo "Domy : ";
echo "
Jabloneck� * ";
echo "
�luknovsk� * ";
echo "
Mimo�sk� 622 * ";
echo "
Mimo�sk� 633 * ";
echo "
Mimo�sk� 644 * ";
echo "
Martinick� * ";
#finalni dotaz do databaze pred vypisem zvolene sestavy
$adresy=MySQL_Query("SELECT c.id as cid, c.komentar as ckomentar, c.*, a.id as aid, a.*, i.id as iid, i.*
FROM (adresy a LEFT JOIN cleni c ON a.clen = c.id)
LEFT JOIN ipecka i ON a.id = i.adresa AND c.id = a.clen
$where AND a.clen > 0 GROUP BY a.id
ORDER BY $order");
echo"
![\"](\"./images/green.jpg\" "\\"")
"; //set green cell
echo "![\"](\"./images/blue.jpg\" "\\"")
"; //set blue cell
echo "![\"nep�ipojeno\"](\"./images/blank_light.jpg\" "\\"$patro.patro")
![\"nep�ipojeno\"](\"./images/blank_dark.jpg\" "\\"$patro.patro")
';
if($show=="all" && $vysledek["active"]==1) $icons=$icons.'
';
if($vysledek["finance"]==1) $icons=$icons.'
';
if($vysledek["internet"]==1) $icons=$icons.'
';
if($vysledek["energy"]==1) $icons=$icons.'
';
if($vysledek["energy"]==2) $icons=$icons.'
';
echo '
';
Next($vysledek);
$row = 3-$row;
}
echo '
