<?php




$boxy = $DB -> getData ( "*", "d_boxy_jmena", "ID <= 3 and visible=1" );

$polozky = $DB -> getData ( "d_boxy_polozky.*, d_produkty.nazevSEO, d_produkty.nazev,d_produkty.hlavniKategorie, d_produkty.cenaBezDPH as cena, d_produkty.foto",
            "d_boxy_polozky, d_produkty", "d_boxy_polozky.IDpolozky = d_produkty.IDproduktu" );

?>

<?php if ( $boxy ) foreach ( $boxy as $var => $b ) {  ?>

     <div class="nadpis"><span><?php echo $b["jmeno"]; ?></span></div>

      <div class="sidebar-right">

          <div class="right-top"></div>
          <div class="box">

    <?php if ( $polozky ) foreach ( $polozky as $p ) {
        if ( $p["IDboxu"] != $b["ID"] ) continue;
        ?>

                 <div class="top-produkt">
                   <div class="nazev-produktu"><h2><a href="<?php echo getFullUrl ( $p["hlavniKategorie"] ); ?>/<?php echo $p["nazevSEO"]; ?>" title="#"><?php echo $p["nazev"]; ?></a></h2></div>
                   <div class="img-produktu"><a href="<?php echo getFullUrl ( $p["hlavniKategorie"] ); ?>/<?php echo $p["nazevSEO"]; ?>" title="#"><img src="/upload/produkty/small/<?Php echo $p["foto"]; ?>" alt="" border="0"></a></div>
                   <div class="cena-produktu"><?php echo my_number_format ( cenaDPH ( $p["cena"] ), 0 ) ?> Kč</div>
                 </div>

        <?php } ?>

            </div>

           <div class="sidebar-right-bottom"></div>

      </div>
<?php } ?>