vypis obrazku pomocou php

<?php

@include_once('hlavicka.php');

require_once('spojit_s_dat.php'); 



unset($what);

unset($how);

unset ($name);





if ($_GET['serad_izieb']) {



    $what = "poc_izb";

    $name = "serad_izieb";

    $how = $_GET['serad_izieb'];



}



if ($_GET['serad_date']) {



    $what = "datum";

    $name = "serad_date";

    $how = $_GET['serad_date'];



}



if ($_GET['serad_obvod']) {



    $what = "obvod";

    $name = "serad_obvod";

    $how = $_GET['serad_obvod'];



}



if (!$what) $what = "id";

if (!$how) $how = "desc";



$vyber = "SELECT COUNT(*) as pocet FROM nehnutelnosti WHERE poc_izb LIKE 'poz%' ";

$vysledok = @mysql_query($vyber); 

$pocet = mysql_result($vysledok, 0, "pocet");



 unset ($next);

unset ($prev); //



if ($_GET['od']) {

    $od = $_GET['od'];

     if ($od + 15 < $pocet) $next = $od + 15;

    if ($od - 15 >= 0) $prev = $od - 15;    //

} else {

    $od = 0;

     $next = 15; //

}



$stranek = ceil($pocet / 15);



$i = 0;



while ($i < $stranek) {

    if ($i * 15 == $od) {

        $menu .= " <span>".($i+1)."</span>";

    } else {

        $menu .= " <a href='pozemky.php?serad_obvod";

        if ($name) $menu .= "=".$how."&amp;";

        $menu .= "&amp;";

        $menu .= "od=".($i*15);

        $menu .= "'>".($i + 1)."</a>";

    }

    $i++;

}



$vyber = "SELECT * FROM nehnutelnosti WHERE poc_izb LIKE 'pozemok%' ORDER BY $what $how LIMIT $od, 15";



$vysledok = @mysql_query($vyber); 



if ($vysledok) { 

/* tuto by malo byt to triedenie. odstranil som odtial tie moje nepodarky nech ta to zbytocne nemyli */

	

echo "<div id='celkove_ohr'><h2>aktuálna ponuka</h2>";

echo "<div style='border:2px;border-left:0px;border-right:0px;border-style:solid;  background-color:#E11E26;color:white;'>

<div style='float: left;margin-left:60px;'>

&nbsp;počet izieb: 

<a href='1izb.php' style='text-decoration:none;font-weight:normal;color:white;'>1</a>, 

<a href='2izb.php' style='text-decoration:none;font-weight:normal;color:white;'>2</a>, 

<a href='3izb.php' style='text-decoration:none;font-weight:normal;color:white;'>3</a>, 

<a href='4izb.php' style='text-decoration:none;font-weight:normal;color:white;'>4</a>, 

<a href='5izb.php' style='text-decoration:none;font-weight:normal;color:white;'>5 a viac</a>, 

<a href='gars.php' style='text-decoration:none;font-weight:normal;color:white;'>gars.</a>  ,

<a href='domy.php' style='text-decoration:none;font-weight:normal;color:white;'>domy</a>,   

<a href='pozemky.php' style='text-decoration:none;font-weight:normal;color:white;'>pozemky</  a>

</div>

<div style='float: right; width: 11%;'>

&nbsp;

&nbsp;dátum</div>

<div style='float: right; width: 15%;'>

<a href='pozemky.php?serad_obvod=asc'><img src='images/triedh.gif' alt='' border='0' /></a>&nbsp;

<a href='pozemky.php?serad_obvod=desc'><img src='images/triedd.gif' alt='' border='0' /></a>&nbsp;obvod</div>

<div style='clear: both; height: 1px; font-size: 1px; line-height: 1px;'></div>

</div><p></p>";



// tuto to konci.



while ($riadok = mysql_fetch_array($vysledok)) { 



echo "<div id='ohr' style='background-color:#E6E6E6;'><div style='float: left; width: 51%;background-color:#E6E6E6;'>&nbsp;&nbsp;

<b>".$riadok['kategoria']."</b>&nbsp;&nbsp;&nbsp;&nbsp;

".$riadok['poc_izb']."

</div><div style='float: right; width: 49%; text-align:right;background-color:#E6E6E6;'>";

if ($riadok['foto']==yes) {  // vloženie fotky

	echo "<img src='images/foto.gif' alt='' border='0' />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;";

}

echo $riadok['obvod'].".&nbsp;&nbsp;&nbsp;

<b>".$riadok['cena']." SK</b>&nbsp;&nbsp;

</div></div><div style='clear: both; height: 1px; font-size: 1px; line-height: 1px;'></div>

<div id='ohr2' style='background-color:#E6E6E6';>

<div style='float: left; width: 67%; background-color:#E6E6E6;padding-left:10px;'>".$riadok['mesto'].",&nbs  p;&nbsp;<b>".$riadok['ulica']."</b>, ".$riadok['text']."

<div style='float:left;width:400px;border:0px none;background-color:#E6E6E6;'>";



$pole = $riadok['upload']; //zavedenie premennej do novej premennej

$rozdel = explode(",",$pole); //rozdelenie pola na jednotlive nazvy

for($i = 1; $i < 50; $i++ ) {

if($rozdel[$i]==FALSE) {

    break;

}



echo "<a href='./upload/full/$rozdel[$i]'>";

echo "<img src=\"./upload/thumb/$rozdel[$i]\" />";

echo "</a>";

}

echo "</div></div>

<div style='float: right; width: 29%; text-align:right; background-color:#E6E6E6;'>".$riadok['datum']."&nbsp;<span style=\"font-size:xx-small\">id=".$riadok['id']."</span>&nbsp;</div>

</div>

<div style='clear: both; height: 1px; font-size: 1px; line-height: 1px;'></div>

<div id='ohr'>&nbsp;</div>";



}



//

if (isset($prev)) {

    echo "<a href='pozemky.php?serad_obvod&";

    if ($name) echo $name."=".$how."&amp;";

    echo "od=$prev";

    echo "'>Späť </a>";

}



if (isset($next)) {

    echo "<a href='pozemky.php?serad_obvod&";

    if ($name) echo $name."=".$how."&amp;";

    echo "od=$next";

    echo "'> Ďalej</a>";

}

// 

echo $menu;

echo "<div id='dole'></div>";

echo '</div>';



mysql_free_result ($vysledok); 



} 



else { 



echo '<p>Zoznam inzerátov sa nedá zobraziť.'.mysql_error().'</p>'; 



}



mysql_close();

@include_once('paticka.php');

?>

<div id="">



</div>

<div style='float:left;width:400px;border:0px none;background-color:#E6E6E6;'>

<a href="./upload/full/zeleznica.jpg">                                          </a>

<a href="./upload/full/razred.jpg">                                       </a>

<a href="./upload/full/pocitek.jpg">                                        </a>

<a href="./upload/full/6prstov.jpg">                                        </a>

</div>