logo.gif, 0 kB

SELECT *, CONCAT_WS(" ",TitulyPrefix, Jmeno, Prijmeni, TitulySuffix) AS clovek FROM uzivatel WHERE ID= LIMIT 1
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'LIMIT 1' at line 1

Seznam psů pro

SELECT pes.ID AS ID, pes.Jmeno AS Jmeno, pes.oID AS oID, pes.mID AS mID, plemeno.Nazev as Varieta, pohlavi.Nazev as Pohlavi, barva.Nazev as Barva, pes.TitulyPredJmenem AS TitulyPredJmenem, pes.plemeno AS Plemeno, pes.UmrtiKomentar AS UmrtiKomentar, CASE WHEN pes.DatUmrti="0000-00-00" THEN "-" ELSE DATE_FORMAT(pes.DatUmrti,"%d.%m.%Y") END AS DatUmrti, CASE WHEN pes.DatNarozeni="0000-00-00" THEN "-" ELSE DATE_FORMAT(pes.DatNarozeni,"%d.%m.%Y") END AS DatNarozeni, CONCAT(LEFT(pes.Jmeno,1),pes.Pohlavi) AS Trideni FROM chovatel LEFT JOIN pes ON pes.ID=chovatel.pID LEFT JOIN ciselnik AS pohlavi ON (pes.Pohlavi=pohlavi.Hodnota && pohlavi.Nazev!="!Typ!" && pohlavi.Typ="pohlavi") LEFT JOIN ciselnik AS plemeno ON (pes.Plemeno=plemeno.Hodnota && plemeno.Nazev!="!Typ!" && plemeno.Typ="plemeno") LEFT JOIN ciselnik AS barva ON (pes.Barva=barva.Hodnota && barva.Nazev!="!Typ!" && barva.Typ="barvy") WHERE chovatel.uID= ORDER BY pes.Jmeno
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ORDER BY pes.Jmeno' at line 16
SELECT pes.ID AS ID, pes.Jmeno AS Jmeno, pes.oID AS oID, pes.mID AS mID, plemeno.Nazev as Varieta, pohlavi.Nazev as Pohlavi, barva.Nazev as Barva, pes.TitulyPredJmenem AS TitulyPredJmenem, pes.plemeno AS Plemeno, pes.UmrtiKomentar AS UmrtiKomentar, CASE WHEN pes.DatUmrti="0000-00-00" THEN "-" ELSE DATE_FORMAT(pes.DatUmrti,"%d.%m.%Y") END AS DatUmrti, CASE WHEN pes.DatNarozeni="0000-00-00" THEN "-" ELSE DATE_FORMAT(pes.DatNarozeni,"%d.%m.%Y") END AS DatNarozeni, CONCAT(LEFT(pes.Jmeno,1),pes.Pohlavi) AS Trideni FROM majitel LEFT JOIN pes ON pes.ID=majitel.pID LEFT JOIN ciselnik AS pohlavi ON (pes.Pohlavi=pohlavi.Hodnota && pohlavi.Nazev!="!Typ!" && pohlavi.Typ="pohlavi") LEFT JOIN ciselnik AS plemeno ON (pes.Plemeno=plemeno.Hodnota && plemeno.Nazev!="!Typ!" && plemeno.Typ="plemeno") LEFT JOIN ciselnik AS barva ON (pes.Barva=barva.Hodnota && barva.Nazev!="!Typ!" && barva.Typ="barvy") WHERE majitel.uID= && majitel.Soucasny=1 ORDER BY pes.Jmeno
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '&& majitel.Soucasny=1 ORDER BY pes.Jmeno' at line 16
SELECT pes.ID AS ID, pes.Jmeno AS Jmeno, pes.oID AS oID, pes.mID AS mID, plemeno.Nazev as Varieta, pohlavi.Nazev as Pohlavi, barva.Nazev as Barva, pes.TitulyPredJmenem AS TitulyPredJmenem, pes.plemeno AS Plemeno, pes.UmrtiKomentar AS UmrtiKomentar, CASE WHEN pes.DatUmrti="0000-00-00" THEN "-" ELSE DATE_FORMAT(pes.DatUmrti,"%d.%m.%Y") END AS DatUmrti, CASE WHEN pes.DatNarozeni="0000-00-00" THEN "-" ELSE DATE_FORMAT(pes.DatNarozeni,"%d.%m.%Y") END AS DatNarozeni, CONCAT(LEFT(pes.Jmeno,1),pes.Pohlavi) AS Trideni FROM majitel LEFT JOIN pes ON pes.ID=majitel.pID LEFT JOIN ciselnik AS pohlavi ON (pes.Pohlavi=pohlavi.Hodnota && pohlavi.Nazev!="!Typ!" && pohlavi.Typ="pohlavi") LEFT JOIN ciselnik AS plemeno ON (pes.Plemeno=plemeno.Hodnota && plemeno.Nazev!="!Typ!" && plemeno.Typ="plemeno") LEFT JOIN ciselnik AS barva ON (pes.Barva=barva.Hodnota && barva.Nazev!="!Typ!" && barva.Typ="barvy") WHERE majitel.uID= && majitel.Soucasny=0 ORDER BY pes.Jmeno
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '&& majitel.Soucasny=0 ORDER BY pes.Jmeno' at line 16
Je uveden/a jako vlastník u:
Seznam je prázdný
Je uveden/a jako dřívější vlastník u:
Seznam je prázdný
Odchoval/a
Seznam je prázdný
bottom.gif, 1 kB