KARTA KOŇA (Card of the horse): ";
echo "
![](foto/".$foto.".jpg)
";
$vyber = mysql_query("SELECT kmen.id as DB_ID,kmen.zivc as ZC,kmen.cislo as Cislo, kmen.meno as Meno,kmen.kmeno,kmen.icotec as Otec,
kmen.icmatka as Matka,
kmen.typ,
kmen.chovtyp,
kmen.dennar,
kmen.roknar,
cispohl.pohlavie,
cisplem.plemeno,
kmen.farba,
kmen.popis,
kmen.pk1,
kmen.pk2,
kmen.pk3,
kmen.pk4,
kmen.rokzar,
kmen.rokvyr,
kmen.kodvyr as Vyradenie,
kmen.kodvykon as Vykonnost,
kmen.rokzv,
kmen.trieda,
kmen.typbody,
kmen.extbody,
kmen.vykonbody,
kmen.kvp,
kmen.kvh,
kmen.ohr,
kmen.ohol,
kmen.hmotnost,
kmen.icchovatel as Chovatel,
kmen.icmajitel as Majitel
FROM kmen LEFT JOIN cisplem ON cisplem.id=kmen.plemeno LEFT JOIN cispohl ON cispohl.id=kmen.pohlavie where kmen.id=$cislo");
//FROM kmen, cispohl, cisplem, cispk where kmen.id=$cislo AND cispohl.id=kmen.pohlavie AND cisplem.id=kmen.plemeno AND cispk.id=kmen.pk1"); // vyberie v�etko z tabu�ky
if (!$vyber) {
die('Invalid query: ' . mysql_error());
}
$pocet_riadkov = mysql_num_rows($vyber); // vyberie po�et riadkov
$pocet_stlpcov = mysql_num_fields($vyber); // vyberie po�et st�pcov
echo "
";
echo "";
while ($riadok = mysql_fetch_array($vyber)) {
for ($r = 0; $r < $pocet_stlpcov; $r++) {
$bunka = $riadok[$r];
$stlpec = mysql_field_name($vyber, $r);
if (($r > 0) && ($stlpec != 'typ') && ($stlpec != 'chovtyp')) {
if (($stlpec == 'Otec') || ($stlpec == 'Matka')) {
if ($stlpec == 'Otec')
$id_otec = $bunka;
if ($stlpec == 'Matka')
$id_matka = $bunka;
$rodicResult = mysql_query("SELECT kmen.meno FROM kmen WHERE kmen.id=$bunka");
if ($rodicResult) {
while ($rodicArr = mysql_fetch_array($rodicResult)) {
$rodic = $rodicArr[0];
}
}
if ($rodic == "") {
$rodic = "-";
if ($stlpec == 'Otec')
echo "$stlpec :
(Sir) | $rodic |
";
else echo "$stlpec :
(Dam) | $rodic |
";
} else {
if ($stlpec == 'Otec')
echo "$stlpec :
(Sir) | " . $em . $bunka . ">$rodic |
";
else echo "$stlpec :
(Dam) | " . $em . $bunka . ">$rodic |
";
}
$rodic = "";
} else if ($stlpec == 'Chovatel') {
$chResult = mysql_query("SELECT cischovmaj.adresa FROM cischovmaj WHERE cischovmaj.id=$bunka");
while ($chArr = mysql_fetch_array($chResult)) {
$chovatel = $chArr[0];
}
echo "Chovateľ :
(Breeder) | $chovatel |
";
$chovatel ="";
} else if ($stlpec == 'Majitel') {
$chResult = mysql_query("SELECT cischovmaj.adresa FROM cischovmaj WHERE cischovmaj.id=$bunka");
while ($chArr = mysql_fetch_array($chResult)) {
$chovatel = $chArr[0];
}
echo "Majiteľ :
(Owner) | $chovatel |
";
$chovatel ="";
} else if ($stlpec == 'Vykonnost') {
$vykResult = mysql_query("SELECT cisvyk.vykon FROM cisvyk WHERE cisvyk.id=$bunka");
while ($vykArr = mysql_fetch_array($vykResult)) {
$vykon = $vykArr[0];
}
echo "Športová výkonnosť :
(Sport capacity value) | $vykon |
";
} else if ($stlpec == 'Vyradenie') {
$vyrResult = mysql_query("SELECT cisvyr.vyradenie FROM cisvyr WHERE cisvyr.id=$bunka");
while ($vyrArr = mysql_fetch_array($vyrResult)) {
$vyradenie = $vyrArr[0];
}
echo "| $stlpec : | $vyradenie |
";
mysql_free_result($vyrResult);
} else if ($stlpec == 'pk1') {
$kod_pk1 = $bunka;
$pkResult = mysql_query("SELECT cispk.plemeno FROM cispk WHERE cispk.id=$bunka");
while ($pkArr = mysql_fetch_array($pkResult)) {
$pk = $pkArr[0];
}
echo "Zapísaný v PK :
(Registered in Stud Book) | $pk ";
mysql_free_result($pkResult);
$pk = "";
} else if (($stlpec == 'pk2') || ($stlpec == 'pk3')) {
$pkResult = mysql_query("SELECT cispk.plemeno FROM cispk WHERE cispk.id=$bunka");
while ($pkArr = mysql_fetch_array($pkResult)) {
$pk = $pkArr[0];
}
//echo " | $pk - | ";
echo "$pk ";
mysql_free_result($pkResult);
$pk = "";
} else if ($stlpec == 'pk4') {
$pkResult = mysql_query("SELECT cispk.plemeno FROM cispk WHERE cispk.id=$bunka");
while ($pkArr = mysql_fetch_array($pkResult)) {
$pk = $pkArr[0];
}
echo "$pk
";
mysql_free_result($pkResult);
$pk = "";
} else if ($stlpec == 'Meno') {
echo "$stlpec :
(Name) | " . $bunka . " |
";
} else {
if ($stlpec == "kmeno")
echo "Kmeňové meno :
(Common name) | " . $bunka . " |
";
else if ($stlpec == "dennar")
echo "Deň narodenia :
(Day of birth) | " . $bunka . " |
";
else if ($stlpec == "roknar")
echo "Rok narodenia :
(Year of birth) | " . $bunka . " |
";
else if ($stlpec == "ZC")
echo "Životné číslo :
(Identification Number) | " . $bunka . " |
";
else if ($stlpec == "Cislo"){
$nameFoto = $bunka+".jpg";
echo "Číslo :
(Number) | " . $bunka . " |
";
}
else if ($stlpec == "pohlavie") {
echo "Pohlavie :
(Sex) | " . $bunka . " |
";
$kod_pohl = $bunka;
} else if ($stlpec == "plemeno")
echo "Plemeno :
(Breed) | " . $bunka . " |
";
else if ($stlpec == "farba")
echo "Farba :
(Colour) | " . $bunka . " |
";
else if ($stlpec == "popis")
echo "Popis :
(Outline diagram/description) | " . $bunka . " |
";
else if ($stlpec == "rokzar")
echo "Rok zaradenia :
(Year of classification) | " . $bunka . " |
";
else if ($stlpec == "rokvyr")
echo "Rok vyradenia :
(Year of disqualification) | " . $bunka . " |
";
else if ($stlpec == "rokzv")
echo "Rok zistenia výkonnosti :
(Year of the sport capacity value detection) | " . $bunka . " |
";
else if ($stlpec == "trieda")
echo "Trieda :
(Class) | " . $bunka . " |
";
else if ($stlpec == "typbody")
echo "Hodnotenie typu :
(Valuation of the type) | " . $bunka . " |
";
else if ($stlpec == "vykonbody")
echo "Hodnotenie výkonnosti :
(Valuation of the sport capacity value) | " . $bunka . " |
";
else if ($stlpec == "extbody")
echo "Hodnotenie exteriéru :
(Valuation of the exterier) | " . $bunka . " |
";
else if ($stlpec == "hmotnost")
echo "Hmotnosť [kg] :
(Weight) | " . $bunka . " |
";
else if ($stlpec == "kvp")
echo "KV Pásková [cm] :
(Tape measure) | " . $bunka . " |
";
else if ($stlpec == "kvh")
echo "KV Palicová [cm] :
(Stick measure) | " . $bunka . " |
";
else if ($stlpec == "ohr")
echo "Obvod hrude [cm] :
(Ribs/breast girth) | " . $bunka . " |
";
else if ($stlpec == "ohol")
echo "Obvod záprstia [cm] :
(Cannon girth) | " . $bunka . " |
";
else
echo "| $stlpec : | " . $bunka . " |
";
}
}
}
$respohl = mysql_query("SELECT kmen.pohlavie FROM kmen WHERE kmen.id=$cislo");
if (!respohl) $kod_pohl =0;
else {
while ($rowpohl = mysql_fetch_array($respohl)) {
$kod_pohl =$rowpohl[0];
}
}
if($kod_pohl == "2"){
$plemenitba = mysql_query("SELECT plem.ickobyla,plem.rokprip, plem.datporod,plem.iczrebec,plem.iczrieba, plem.menozrieba FROM plem WHERE plem.ickobyla=$cislo"); // vyberie v�etko z tabu�ky
if (!$plemenitba) {
echo "Plemenitba :
(Inbreeding) | - |
";
}
$pocet_riadkovplem = mysql_num_rows($plemenitba); // vyberie po�et riadkov
$pocet_stlpcovplem = mysql_num_fields($plemenitba); // vyberie po�et st�pcov
if ($pocet_riadkovplem > 0)
echo "Plemenitba :
(Inbreeding) | " . $plem . $cislo . ">Plemenitba |
";
else
echo "Plemenitba :
(Inbreeding) | - |
";
} else if ($kod_pohl == "1") {
$plemenitba = mysql_query("SELECT plem.ickobyla,plem.rokprip, plem.datporod,plem.iczrebec,plem.iczrieba, plem.menozrieba FROM plem WHERE plem.iczrebec=$cislo"); // vyberie v�etko z tabu�ky
if (!$plemenitba) {
echo "Plemenitba :
(Inbreeding) | - |
";
}
$pocet_riadkovplem = mysql_num_rows($plemenitba); // vyberie po�et riadkov
$pocet_stlpcovplem = mysql_num_fields($plemenitba); // vyberie po�et st�pcov
if ($pocet_riadkovplem > 0)
echo "Plemenitba :
(Inbreeding) | " . $plemzr . $cislo . ">Plemenitba |
";
else
echo "Plemenitba :
(Inbreeding) | - |
";
}
echo "
Pôvod (Pedigree):";
echo "";
echo "";
// zistim otcove udaje a zapisem do povodu
$povodResult = mysql_query("SELECT kmen.id,kmen.meno,cisplem.plemeno,kmen.roknar,kmen.icotec,kmen.icmatka FROM kmen LEFT JOIN cisplem ON cisplem.id=kmen.plemeno where kmen.id=$id_otec");
if ((!$povodResult ) || (mysql_num_rows($povodResult) < 1))
echo "| - | ";
else {
while ($predokArr = mysql_fetch_array($povodResult)) {
$predokId = $predokArr[0];
$predokMeno = $predokArr[1];
$predokPlemeno = $predokArr[2];
$predokRokNar = $predokArr[3];
$Idoo = $predokArr[4];
$Idmo = $predokArr[5];
}
mysql_free_result($povodResult);
echo "" . $em . $predokId . ">" . $predokMeno . "
" . $predokPlemeno . "
(" . $predokRokNar . ")- | ";
}
// zistim oo udaje a zapisem do povodu
$povodResult = mysql_query("SELECT kmen.id,kmen.meno,cisplem.plemeno,kmen.roknar,kmen.icotec,kmen.icmatka FROM kmen LEFT JOIN cisplem ON cisplem.id=kmen.plemeno where kmen.id=$Idoo");
if ((!$povodResult ) || (mysql_num_rows($povodResult) < 1))
echo "- | ";
else {
while ($predokArr = mysql_fetch_array($povodResult)) {
$predokId = $predokArr[0];
$predokMeno = $predokArr[1];
$predokPlemeno = $predokArr[2];
$predokRokNar = $predokArr[3];
$Idooo = $predokArr[4];
$Idmoo = $predokArr[5];
}
mysql_free_result($povodResult);
echo "" . $em . $predokId . ">" . $predokMeno . "
" . $predokPlemeno . "
(" . $predokRokNar . ")- | ";
}
// zistim ooo udaje a zapisem do povodu
$povodResult = mysql_query("SELECT kmen.id,kmen.meno,cisplem.plemeno,kmen.roknar,kmen.icotec,kmen.icmatka FROM kmen LEFT JOIN cisplem ON cisplem.id=kmen.plemeno where kmen.id=$Idooo");
if ((!$povodResult ) || (mysql_num_rows($povodResult) < 1))
echo "- | ";
else {
while ($predokArr = mysql_fetch_array($povodResult)) {
$predokId = $predokArr[0];
$predokMeno = $predokArr[1];
$predokPlemeno = $predokArr[2];
$predokRokNar = $predokArr[3];
$Idoooo = $predokArr[4];
$Idmooo = $predokArr[5];
}
mysql_free_result($povodResult);
echo "" . $em . $predokId . ">" . $predokMeno . "
" . $predokPlemeno . "
(" . $predokRokNar . ")- | ";
}
// zistim oooo udaje a zapisem do povodu
$povodResult = mysql_query("SELECT kmen.id,kmen.meno,cisplem.plemeno,kmen.roknar,kmen.icotec,kmen.icmatka FROM kmen LEFT JOIN cisplem ON cisplem.id=kmen.plemeno where kmen.id=$Idoooo");
if ((!$povodResult ) || (mysql_num_rows($povodResult) < 1))
echo "- | ";
else {
while ($predokArr = mysql_fetch_array($povodResult)) {
$predokId = $predokArr[0];
$predokMeno = $predokArr[1];
$predokPlemeno = $predokArr[2];
$predokRokNar = $predokArr[3];
$Idooooo = $predokArr[4];
$Idmoooo = $predokArr[5];
}
mysql_free_result($povodResult);
echo "" . $em . $predokId . ">" . $predokMeno . "
" . $predokPlemeno . "
(" . $predokRokNar . ")- | ";
}
echo "
";
echo "";
// zistim mooo udaje a zapisem do povodu
$povodResult = mysql_query("SELECT kmen.id,kmen.meno,cisplem.plemeno,kmen.roknar,kmen.icotec,kmen.icmatka FROM kmen LEFT JOIN cisplem ON cisplem.id=kmen.plemeno where kmen.id=$Idmooo");
if ((!$povodResult ) || (mysql_num_rows($povodResult) < 1))
echo "| - | ";
else {
while ($predokArr = mysql_fetch_array($povodResult)) {
$predokId = $predokArr[0];
$predokMeno = $predokArr[1];
$predokPlemeno = $predokArr[2];
$predokRokNar = $predokArr[3];
$Idomooo = $predokArr[4];
$Idmoooo = $predokArr[5];
}
mysql_free_result($povodResult);
echo "" . $em . $predokId . ">" . $predokMeno . "
" . $predokPlemeno . "
(" . $predokRokNar . ")- | ";
}
echo "
";
echo "";
// zistim moo udaje a zapisem do povodu
$povodResult = mysql_query("SELECT kmen.id,kmen.meno,cisplem.plemeno,kmen.roknar,kmen.icotec,kmen.icmatka FROM kmen LEFT JOIN cisplem ON cisplem.id=kmen.plemeno where kmen.id=$Idmoo");
if ((!$povodResult ) || (mysql_num_rows($povodResult) < 1))
echo "| - | ";
else {
while ($predokArr = mysql_fetch_array($povodResult)) {
$predokId = $predokArr[0];
$predokMeno = $predokArr[1];
$predokPlemeno = $predokArr[2];
$predokRokNar = $predokArr[3];
$Idomoo = $predokArr[4];
$Idmmoo = $predokArr[5];
}
mysql_free_result($povodResult);
echo "" . $em . $predokId . ">" . $predokMeno . "
" . $predokPlemeno . "
(" . $predokRokNar . ")- | ";
}
// zistim omoo udaje a zapisem do povodu
$povodResult = mysql_query("SELECT kmen.id,kmen.meno,cisplem.plemeno,kmen.roknar,kmen.icotec,kmen.icmatka FROM kmen LEFT JOIN cisplem ON cisplem.id=kmen.plemeno where kmen.id=$Idomoo");
if ((!$povodResult ) || (mysql_num_rows($povodResult) < 1))
echo "- | ";
else {
while ($predokArr = mysql_fetch_array($povodResult)) {
$predokId = $predokArr[0];
$predokMeno = $predokArr[1];
$predokPlemeno = $predokArr[2];
$predokRokNar = $predokArr[3];
$Idoomoo = $predokArr[4];
$Idmomoo = $predokArr[5];
}
mysql_free_result($povodResult);
echo "" . $em . $predokId . ">" . $predokMeno . "
" . $predokPlemeno . "
(" . $predokRokNar . ")- | ";
}
echo "
";
echo "";
// zistim mmoo udaje a zapisem do povodu
$povodResult = mysql_query("SELECT kmen.id,kmen.meno,cisplem.plemeno,kmen.roknar,kmen.icotec,kmen.icmatka FROM kmen LEFT JOIN cisplem ON cisplem.id=kmen.plemeno where kmen.id=$Idmmoo");
if ((!$povodResult ) || (mysql_num_rows($povodResult) < 1))
echo "| - | ";
else {
while ($predokArr = mysql_fetch_array($povodResult)) {
$predokId = $predokArr[0];
$predokMeno = $predokArr[1];
$predokPlemeno = $predokArr[2];
$predokRokNar = $predokArr[3];
$Idommoo = $predokArr[4];
$Idmmmoo = $predokArr[5];
}
mysql_free_result($povodResult);
echo "" . $em . $predokId . ">" . $predokMeno . "
" . $predokPlemeno . "
(" . $predokRokNar . ")- | ";
}
echo "
";
echo "";
// zistim mo udaje a zapisem do povodu
$povodResult = mysql_query("SELECT kmen.id,kmen.meno,cisplem.plemeno,kmen.roknar,kmen.icotec,kmen.icmatka FROM kmen LEFT JOIN cisplem ON cisplem.id=kmen.plemeno where kmen.id=$Idmo");
if ((!$povodResult ) || (mysql_num_rows($povodResult) < 1))
echo "| - | ";
else {
while ($predokArr = mysql_fetch_array($povodResult)) {
$predokId = $predokArr[0];
$predokMeno = $predokArr[1];
$predokPlemeno = $predokArr[2];
$predokRokNar = $predokArr[3];
$Idomo = $predokArr[4];
$Idmmo = $predokArr[5];
}
mysql_free_result($povodResult);
echo "" . $em . $predokId . ">" . $predokMeno . "
" . $predokPlemeno . "
(" . $predokRokNar . ")- | ";
}
// zistim omo udaje a zapisem do povodu
$povodResult = mysql_query("SELECT kmen.id,kmen.meno,cisplem.plemeno,kmen.roknar,kmen.icotec,kmen.icmatka FROM kmen LEFT JOIN cisplem ON cisplem.id=kmen.plemeno where kmen.id=$Idomo");
if ((!$povodResult ) || (mysql_num_rows($povodResult) < 1))
echo "- | ";
else {
while ($predokArr = mysql_fetch_array($povodResult)) {
$predokId = $predokArr[0];
$predokMeno = $predokArr[1];
$predokPlemeno = $predokArr[2];
$predokRokNar = $predokArr[3];
$Idoomo = $predokArr[4];
$Idmomo = $predokArr[5];
}
mysql_free_result($povodResult);
echo "" . $em . $predokId . ">" . $predokMeno . "
" . $predokPlemeno . "
(" . $predokRokNar . ")- | ";
}
// zistim oomo udaje a zapisem do povodu
$povodResult = mysql_query("SELECT kmen.id,kmen.meno,cisplem.plemeno,kmen.roknar,kmen.icotec,kmen.icmatka FROM kmen LEFT JOIN cisplem ON cisplem.id=kmen.plemeno where kmen.id=$Idoomo");
if ((!$povodResult ) || (mysql_num_rows($povodResult) < 1))
echo "- | ";
else {
while ($predokArr = mysql_fetch_array($povodResult)) {
$predokId = $predokArr[0];
$predokMeno = $predokArr[1];
$predokPlemeno = $predokArr[2];
$predokRokNar = $predokArr[3];
$Idooomo = $predokArr[4];
$Idmoomo = $predokArr[5];
}
mysql_free_result($povodResult);
echo "" . $em . $predokId . ">" . $predokMeno . "
" . $predokPlemeno . "
(" . $predokRokNar . ")- | ";
}
echo "
";
echo "";
// zistim momo udaje a zapisem do povodu
$povodResult = mysql_query("SELECT kmen.id,kmen.meno,cisplem.plemeno,kmen.roknar,kmen.icotec,kmen.icmatka FROM kmen LEFT JOIN cisplem ON cisplem.id=kmen.plemeno where kmen.id=$Idmomo");
if ((!$povodResult ) || (mysql_num_rows($povodResult) < 1))
echo "| - | ";
else {
while ($predokArr = mysql_fetch_array($povodResult)) {
$predokId = $predokArr[0];
$predokMeno = $predokArr[1];
$predokPlemeno = $predokArr[2];
$predokRokNar = $predokArr[3];
$Idomomo = $predokArr[4];
$Idmmomo = $predokArr[5];
}
mysql_free_result($povodResult);
echo "" . $em . $predokId . ">" . $predokMeno . "
" . $predokPlemeno . "
(" . $predokRokNar . ")- | ";
}
echo "
";
echo "";
// zistim mmo udaje a zapisem do povodu
$povodResult = mysql_query("SELECT kmen.id,kmen.meno,cisplem.plemeno,kmen.roknar,kmen.icotec,kmen.icmatka FROM kmen LEFT JOIN cisplem ON cisplem.id=kmen.plemeno where kmen.id=$Idmmo");
if ((!$povodResult ) || (mysql_num_rows($povodResult) < 1))
echo "| - | ";
else {
while ($predokArr = mysql_fetch_array($povodResult)) {
$predokId = $predokArr[0];
$predokMeno = $predokArr[1];
$predokPlemeno = $predokArr[2];
$predokRokNar = $predokArr[3];
$Idommo = $predokArr[4];
$Idmmmo = $predokArr[5];
}
mysql_free_result($povodResult);
echo "" . $em . $predokId . ">" . $predokMeno . "
" . $predokPlemeno . "
(" . $predokRokNar . ")- | ";
}
// zistim ommo udaje a zapisem do povodu
$povodResult = mysql_query("SELECT kmen.id,kmen.meno,cisplem.plemeno,kmen.roknar,kmen.icotec,kmen.icmatka FROM kmen LEFT JOIN cisplem ON cisplem.id=kmen.plemeno where kmen.id=$Idommo");
if ((!$povodResult ) || (mysql_num_rows($povodResult) < 1))
echo "- | ";
else {
while ($predokArr = mysql_fetch_array($povodResult)) {
$predokId = $predokArr[0];
$predokMeno = $predokArr[1];
$predokPlemeno = $predokArr[2];
$predokRokNar = $predokArr[3];
$Idoommo = $predokArr[4];
$Idmommo = $predokArr[5];
}
mysql_free_result($povodResult);
echo "" . $em . $predokId . ">" . $predokMeno . "
" . $predokPlemeno . "
(" . $predokRokNar . ")- | ";
}
echo "
";
echo "";
// zistim mmmo udaje a zapisem do povodu
$povodResult = mysql_query("SELECT kmen.id,kmen.meno,cisplem.plemeno,kmen.roknar,kmen.icotec,kmen.icmatka FROM kmen LEFT JOIN cisplem ON cisplem.id=kmen.plemeno where kmen.id=$Idmmmo");
if ((!$povodResult ) || (mysql_num_rows($povodResult) < 1))
echo "| - | ";
else {
while ($predokArr = mysql_fetch_array($povodResult)) {
$predokId = $predokArr[0];
$predokMeno = $predokArr[1];
$predokPlemeno = $predokArr[2];
$predokRokNar = $predokArr[3];
$Idommmo = $predokArr[4];
$Idmmmmo = $predokArr[5];
}
mysql_free_result($povodResult);
echo "" . $em . $predokId . ">" . $predokMeno . "
" . $predokPlemeno . "
(" . $predokRokNar . ")- | ";
}
echo "
";
echo "";
// zistim matkine udaje a zapisem do povodu
$povodResult = mysql_query("SELECT kmen.id,kmen.meno,cisplem.plemeno,kmen.roknar,kmen.icotec,kmen.icmatka FROM kmen LEFT JOIN cisplem ON cisplem.id=kmen.plemeno where kmen.id=$id_matka");
if ((!$povodResult) || (mysql_num_rows($povodResult) < 1))
echo "| - | ";
else {
while ($predokArr = mysql_fetch_array($povodResult)) {
$predokId = $predokArr[0];
$predokMeno = $predokArr[1];
$predokPlemeno = $predokArr[2];
$predokRokNar = $predokArr[3];
$Idom = $predokArr[4];
$Idmm = $predokArr[5];
}
mysql_free_result($povodResult);
echo "" . $em . $predokId . ">" . $predokMeno . "
" . $predokPlemeno . "
(" . $predokRokNar . ")- | ";
}
// zistim om udaje a zapisem do povodu
$povodResult = mysql_query("SELECT kmen.id,kmen.meno,cisplem.plemeno,kmen.roknar,kmen.icotec,kmen.icmatka FROM kmen LEFT JOIN cisplem ON cisplem.id=kmen.plemeno where kmen.id=$Idom");
if ((!$povodResult) || (mysql_num_rows($povodResult) < 1))
echo "- | ";
else {
while ($predokArr = mysql_fetch_array($povodResult)) {
$predokId = $predokArr[0];
$predokMeno = $predokArr[1];
$predokPlemeno = $predokArr[2];
$predokRokNar = $predokArr[3];
$Idoom = $predokArr[4];
$Idmom = $predokArr[5];
}
mysql_free_result($povodResult);
echo "" . $em . $predokId . ">" . $predokMeno . "
" . $predokPlemeno . "
(" . $predokRokNar . ")- | ";
}
// zistim oom udaje a zapisem do povodu
$povodResult = mysql_query("SELECT kmen.id,kmen.meno,cisplem.plemeno,kmen.roknar,kmen.icotec,kmen.icmatka FROM kmen LEFT JOIN cisplem ON cisplem.id=kmen.plemeno where kmen.id=$Idoom");
if ((!$povodResult) || (mysql_num_rows($povodResult) < 1))
echo "- | ";
else {
while ($predokArr = mysql_fetch_array($povodResult)) {
$predokId = $predokArr[0];
$predokMeno = $predokArr[1];
$predokPlemeno = $predokArr[2];
$predokRokNar = $predokArr[3];
$Idooom = $predokArr[4];
$Idmoom = $predokArr[5];
}
mysql_free_result($povodResult);
echo "" . $em . $predokId . ">" . $predokMeno . "
" . $predokPlemeno . "
(" . $predokRokNar . ")- | ";
}
// zistim ooom udaje a zapisem do povodu
$povodResult = mysql_query("SELECT kmen.id,kmen.meno,cisplem.plemeno,kmen.roknar,kmen.icotec,kmen.icmatka FROM kmen LEFT JOIN cisplem ON cisplem.id=kmen.plemeno where kmen.id=$Idooom");
if ((!$povodResult) || (mysql_num_rows($povodResult) < 1))
echo "- | ";
else {
while ($predokArr = mysql_fetch_array($povodResult)) {
$predokId = $predokArr[0];
$predokMeno = $predokArr[1];
$predokPlemeno = $predokArr[2];
$predokRokNar = $predokArr[3];
$Idoooom = $predokArr[4];
$Idmomom = $predokArr[5];
}
mysql_free_result($povodResult);
echo "" . $em . $predokId . ">" . $predokMeno . "
" . $predokPlemeno . "
(" . $predokRokNar . ")- | ";
}
echo "
";
echo "";
// zistim moom udaje a zapisem do povodu
$povodResult = mysql_query("SELECT kmen.id,kmen.meno,cisplem.plemeno,kmen.roknar,kmen.icotec,kmen.icmatka FROM kmen LEFT JOIN cisplem ON cisplem.id=kmen.plemeno where kmen.id=$Idmoom");
if ((!$povodResult) || (mysql_num_rows($povodResult) < 1))
echo "| - | ";
else {
while ($predokArr = mysql_fetch_array($povodResult)) {
$predokId = $predokArr[0];
$predokMeno = $predokArr[1];
$predokPlemeno = $predokArr[2];
$predokRokNar = $predokArr[3];
$Idomoom = $predokArr[4];
$Idmmoom = $predokArr[5];
}
mysql_free_result($povodResult);
echo "" . $em . $predokId . ">" . $predokMeno . "
" . $predokPlemeno . "
(" . $predokRokNar . ")- | ";
}
echo "
";
echo "";
// zistim mom udaje a zapisem do povodu
$povodResult = mysql_query("SELECT kmen.id,kmen.meno,cisplem.plemeno,kmen.roknar,kmen.icotec,kmen.icmatka FROM kmen LEFT JOIN cisplem ON cisplem.id=kmen.plemeno where kmen.id=$Idmom");
if ((!$povodResult) || (mysql_num_rows($povodResult) < 1))
echo "| - | ";
else {
while ($predokArr = mysql_fetch_array($povodResult)) {
$predokId = $predokArr[0];
$predokMeno = $predokArr[1];
$predokPlemeno = $predokArr[2];
$predokRokNar = $predokArr[3];
$Idomom = $predokArr[4];
$Idmmom = $predokArr[5];
}
mysql_free_result($povodResult);
echo "" . $em . $predokId . ">" . $predokMeno . "
" . $predokPlemeno . "
(" . $predokRokNar . ")- | ";
}
// zistim omom udaje a zapisem do povodu
$povodResult = mysql_query("SELECT kmen.id,kmen.meno,cisplem.plemeno,kmen.roknar,kmen.icotec,kmen.icmatka FROM kmen LEFT JOIN cisplem ON cisplem.id=kmen.plemeno where kmen.id=$Idomom");
if ((!$povodResult) || (mysql_num_rows($povodResult) < 1))
echo "- | ";
else {
while ($predokArr = mysql_fetch_array($povodResult)) {
$predokId = $predokArr[0];
$predokMeno = $predokArr[1];
$predokPlemeno = $predokArr[2];
$predokRokNar = $predokArr[3];
$Idoomom = $predokArr[4];
$Idmomom = $predokArr[5];
}
mysql_free_result($povodResult);
echo "" . $em . $predokId . ">" . $predokMeno . "
" . $predokPlemeno . "
(" . $predokRokNar . ")- | ";
}
echo "
";
echo "";
// zistim mmom udaje a zapisem do povodu
$povodResult = mysql_query("SELECT kmen.id,kmen.meno,cisplem.plemeno,kmen.roknar,kmen.icotec,kmen.icmatka FROM kmen LEFT JOIN cisplem ON cisplem.id=kmen.plemeno where kmen.id=$Idmmom");
if ((!$povodResult) || (mysql_num_rows($povodResult) < 1))
echo "| - | ";
else {
while ($predokArr = mysql_fetch_array($povodResult)) {
$predokId = $predokArr[0];
$predokMeno = $predokArr[1];
$predokPlemeno = $predokArr[2];
$predokRokNar = $predokArr[3];
$Idommom = $predokArr[4];
$Idmmmom = $predokArr[5];
}
mysql_free_result($povodResult);
echo "" . $em . $predokId . ">" . $predokMeno . "
" . $predokPlemeno . "
(" . $predokRokNar . ")- | ";
}
echo "
";
echo "";
// zistim mm udaje a zapisem do povodu
$povodResult = mysql_query("SELECT kmen.id,kmen.meno,cisplem.plemeno,kmen.roknar,kmen.icotec,kmen.icmatka FROM kmen LEFT JOIN cisplem ON cisplem.id=kmen.plemeno where kmen.id=$Idmm");
if ((!$povodResult) || (mysql_num_rows($povodResult) < 1))
echo "| - | ";
else {
while ($predokArr = mysql_fetch_array($povodResult)) {
$predokId = $predokArr[0];
$predokMeno = $predokArr[1];
$predokPlemeno = $predokArr[2];
$predokRokNar = $predokArr[3];
$Idomm = $predokArr[4];
$Idmmm = $predokArr[5];
}
mysql_free_result($povodResult);
echo "" . $em . $predokId . ">" . $predokMeno . "
" . $predokPlemeno . "
(" . $predokRokNar . ")- | ";
}
// zistim omm udaje a zapisem do povodu
$povodResult = mysql_query("SELECT kmen.id,kmen.meno,cisplem.plemeno,kmen.roknar,kmen.icotec,kmen.icmatka FROM kmen LEFT JOIN cisplem ON cisplem.id=kmen.plemeno where kmen.id=$Idomm");
if ((!$povodResult) || (mysql_num_rows($povodResult) < 1))
echo "- | ";
else {
while ($predokArr = mysql_fetch_array($povodResult)) {
$predokId = $predokArr[0];
$predokMeno = $predokArr[1];
$predokPlemeno = $predokArr[2];
$predokRokNar = $predokArr[3];
$Idoomm = $predokArr[4];
$Idmomm = $predokArr[5];
}
mysql_free_result($povodResult);
echo "" . $em . $predokId . ">" . $predokMeno . "
" . $predokPlemeno . "
(" . $predokRokNar . ")- | ";
}
// zistim oomm udaje a zapisem do povodu
$povodResult = mysql_query("SELECT kmen.id,kmen.meno,cisplem.plemeno,kmen.roknar,kmen.icotec,kmen.icmatka FROM kmen LEFT JOIN cisplem ON cisplem.id=kmen.plemeno where kmen.id=$Idoomm");
if ((!$povodResult) || (mysql_num_rows($povodResult) < 1))
echo "- | ";
else {
while ($predokArr = mysql_fetch_array($povodResult)) {
$predokId = $predokArr[0];
$predokMeno = $predokArr[1];
$predokPlemeno = $predokArr[2];
$predokRokNar = $predokArr[3];
$Idooomm = $predokArr[4];
$Idmoomm = $predokArr[5];
}
mysql_free_result($povodResult);
echo "" . $em . $predokId . ">" . $predokMeno . "
" . $predokPlemeno . "
(" . $predokRokNar . ")- | ";
}
echo "
";
echo "";
// zistim momm udaje a zapisem do povodu
$povodResult = mysql_query("SELECT kmen.id,kmen.meno,cisplem.plemeno,kmen.roknar,kmen.icotec,kmen.icmatka FROM kmen LEFT JOIN cisplem ON cisplem.id=kmen.plemeno where kmen.id=$Idmomm");
if ((!$povodResult) || (mysql_num_rows($povodResult) < 1))
echo "| - | ";
else {
while ($predokArr = mysql_fetch_array($povodResult)) {
$predokId = $predokArr[0];
$predokMeno = $predokArr[1];
$predokPlemeno = $predokArr[2];
$predokRokNar = $predokArr[3];
$Idomomm = $predokArr[4];
$Idmmomm = $predokArr[5];
}
mysql_free_result($povodResult);
echo "" . $em . $predokId . ">" . $predokMeno . "
" . $predokPlemeno . "
(" . $predokRokNar . ")- | ";
}
echo "
";
echo "";
// zistim mmm udaje a zapisem do povodu
$povodResult = mysql_query("SELECT kmen.id,kmen.meno,cisplem.plemeno,kmen.roknar,kmen.icotec,kmen.icmatka FROM kmen LEFT JOIN cisplem ON cisplem.id=kmen.plemeno where kmen.id=$Idmmm");
if ((!$povodResult) || (mysql_num_rows($povodResult) < 1))
echo "| - | ";
else {
while ($predokArr = mysql_fetch_array($povodResult)) {
$predokId = $predokArr[0];
$predokMeno = $predokArr[1];
$predokPlemeno = $predokArr[2];
$predokRokNar = $predokArr[3];
$Idommm = $predokArr[4];
$Idmmmm = $predokArr[5];
}
mysql_free_result($povodResult);
echo "" . $em . $predokId . ">" . $predokMeno . "
" . $predokPlemeno . "
(" . $predokRokNar . ")- | ";
}
// zistim ommm udaje a zapisem do povodu
$povodResult = mysql_query("SELECT kmen.id,kmen.meno,cisplem.plemeno,kmen.roknar,kmen.icotec,kmen.icmatka FROM kmen LEFT JOIN cisplem ON cisplem.id=kmen.plemeno where kmen.id=$Idommm");
if ((!$povodResult) || (mysql_num_rows($povodResult) < 1))
echo "- | ";
else {
while ($predokArr = mysql_fetch_array($povodResult)) {
$predokId = $predokArr[0];
$predokMeno = $predokArr[1];
$predokPlemeno = $predokArr[2];
$predokRokNar = $predokArr[3];
$Idoommm = $predokArr[4];
$Idmoomm = $predokArr[5];
}
mysql_free_result($povodResult);
echo "" . $em . $predokId . ">" . $predokMeno . "
" . $predokPlemeno . "
(" . $predokRokNar . ")- | ";
}
echo "
";
echo "";
// zistim mmmm udaje a zapisem do povodu
$povodResult = mysql_query("SELECT kmen.id,kmen.meno,cisplem.plemeno,kmen.roknar,kmen.icotec,kmen.icmatka FROM kmen LEFT JOIN cisplem ON cisplem.id=kmen.plemeno where kmen.id=$Idmmmm");
if ((!$povodResult) || (mysql_num_rows($povodResult) < 1))
echo "| - | ";
else {
while ($predokArr = mysql_fetch_array($povodResult)) {
$predokId = $predokArr[0];
$predokMeno = $predokArr[1];
$predokPlemeno = $predokArr[2];
$predokRokNar = $predokArr[3];
$Idommmm = $predokArr[4];
$Idmmmmm = $predokArr[5];
}
mysql_free_result($povodResult);
echo "" . $em . $predokId . ">" . $predokMeno . "
" . $predokPlemeno . "
(" . $predokRokNar . ")- | ";
}
echo "
";
echo "
";
echo "";
$poradie++; // pripo��ta 1 ku poradiu riadkov
}
echo "";
echo "
";
//echo "Kod plem knihy";
//echo $kod_pk1;
}
mysql_tabulka($_GET['cislo'],$_GET['foto']);
echo "
Hlavná stránka PK
";
?>