 |
$hlp = URLDecode($hlp);
$sepos = URLDecode($sepos);
$tabulka1_odkud = "obrazky";
$tabulka2_odkud = "popelnice";
$indian=0;
if (Ereg("@", $hlp)): //zkoumáme, zda bylo klepnuto na název s druhem
List($druh_pamatky, $nazev_pamatky) = Explode("@", $hlp);
$where_clause = "Druh LIKE '$druh_pamatky' AND Misto LIKE '$nazev_pamatky'";
else:
$where_clause = "Misto LIKE '$hlp'";
endif;
if ($sepos):
$name_qr = MySQL_Query("SELECT Id_poh, Druh, Misto, Popis, Autor, Adresa FROM obrazky WHERE (Misto LIKE '%$sepos%') OR (Popis LIKE '%$sepos%') OR (Autor LIKE '%$sepos%') ORDER BY Porad", $spojeni);
else:
$name_qr = MySQL_Query("SELECT Id_poh, Druh, Misto, Popis, Autor, Adresa FROM ".$tabulka1_odkud." WHERE $where_clause ORDER BY Porad", $spojeni);
endif;
$xl = MySQL_Num_Rows($name_qr);
if ($xs == 0) $xs = 18;
$i = $xs * $p;
if (!$z AND $sepos):
if ($xl > 300):
$xl = 300;
endif;
endif;
if ($xl):
$hlp = URLEncode($hlp);
$sepos = URLEncode($sepos);
$sufix = "&hlp=$hlp&sepos=$sepos&z=$z";
$deleni_od = $SCRIPT_NAME;
include "../_pages/in_deleni.php3";
MySQL_Data_Seek($name_qr, $i-1);
if ($xl>18) echo " ".$rl."";
while (($name_pole = MySQL_Fetch_Array($name_qr)) && $i<=$xs*$p && $i <= $xl):
$yde[$indian] = $name_pole["Id_poh"];
$kolkoraz_poslane_qr = MySQL_Query("SELECT Poslano FROM ".$tabulka2_odkud." WHERE Id_pohled = $yde[$indian]", $spojeni);
$kolkoraz_poslane_pole = MySQL_Fetch_Array($kolkoraz_poslane_qr);
$poslano[$indian] = $kolkoraz_poslane_pole["Poslano"];
$jmeno[$indian] = $name_pole["Adresa"];
$drouzek[$indian] = $name_pole["Druh"];
$mistecko[$indian] = $name_pole["Misto"];
$popisek[$indian] = $name_pole["Popis"];
$autor[$indian] = $name_pole["Autor"];
++$indian;
$i++;
if ($i < $xl) MySQL_Data_Seek($name_qr, $i-1);
endwhile;
$radku = Ceil($indian/3);
$pow = 0;
$start = 0;
$stop = $radku;
for ($ii=0;$ii<$radku;$ii++):
echo "";
for ($qq=0;$qq<3;$qq++):
if ($popisek[$pow]!=""):
$altus[$pow] = $drouzek[$pow]." ".$mistecko[$pow].", ".$popisek[$pow];
else:
$altus[$pow] = $drouzek[$pow]." ".$mistecko[$pow];
endif;
if ($pow>=$indian):
echo "| | ";
else:
echo "
![\"$altus[$pow]\"](\"../_pictures/p/n/$jmeno[$pow]\") ".
" ";
if ($popisek[$pow]!="") echo $popisek[$pow]." ";
if ($autor[$pow]!="") echo "Autor: ".$autor[$pow]." | ";
endif;
++$pow;
endfor;
echo " ";
endfor;
echo " ".$rl."";
endif;
?>
|
 |