"; if ($_GET[id] != ""): $kde = "WHERE prodejni_mista.idZeme='$_GET[id]'"; else: $kde = ""; endif; $result = mysql_query("SELECT prodejni_mista.*, zeme.nazev AS zeme FROM prodejni_mista LEFT JOIN zeme ON prodejni_mista.idZeme = zeme.id $kde ORDER BY nazev"); if (mysql_num_rows($result) != 0): while ($row=mysql_fetch_array($result)){ echo " "; } endif; ?>

$row[nazev]
$row[adresa]
$row[zeme]

E-mail: $row[email]
Tel.: $row[telefon]

<< na hlavní stránku