[es] - Kako iscrtati tabelu koja bi imala tacno odredjen broj <TD> ova na osnovu rezultata iz baze?

vladimirn
Vladimir Nikolic
Novi Sad

Član broj: 38585
Poruke: 81
*.static.sbb.co.yu.

Profil

Kako iscrtati tabelu koja bi imala tacno odredjen broj <TD> ova na osnovu rezultata iz baze?

^{24.12.2007. u 10:12 - pre 198 meseci}

Napravio sam tabelu koja u sebi nosi vrednosti iz baze.
Te vrednosti su nazivi kategorija. Ono sto me muci je da ukoliko imam vise od 6 kategorija, moja tabela ispisuje <td> za svaku kategoriju i onda se rasiri preko cele stranice, tako da ispadne iz dizajna.
Ja bih zeleo da ispise samo 6 podkategorija, i da onda sledecih 6 recimo prebaci u novi red.

Ovako sam napisao kod koji sada imam:

Code:

function checkChildSvi($catID){
        global $smarty, $conn;
        $sql ="select * from categories  where parent ='$catID' order by catID";
        $result = $conn->Execute($sql);
        while ($row=$result->FetchRow()) {
            $id = $row['catID'];
            $sqlcount = "select SQL_CALC_FOUND_ROWS i.itemID, c.catID, c.catName    from items i , categories c where i.itemID in(select  distinct(itemID) from cat_items where catID = $id)  group by itemName order by catName ";
            $resultCount = $conn->Execute($sqlcount);
            $sqlcount = "SELECT FOUND_ROWS() as total";
            $_result = mysql_query($sqlcount);
            $_row = mysql_fetch_array($_result, MYSQL_ASSOC);
            $izbroj = $_row['total'];
            if($id == $_REQUEST['catID']){$bold = "font-weight:bold";}else{$bold = "";}
                $child .= "<div style='margin-left:8px;background-color:' class='subcat".$catID."' >  <a href=\"".$HTTP_SERVER_VARS['REQUEST_URI']."i2.php?tabid=".$_REQUEST['tabid']."&tabindex=".$_REQUEST['tabindex']."&portalid=".$_REQUEST['portalid']."&a=view&catID=".$row['catID']."\" >"."<span style='$bold'>".$row['catName']."(".$izbroj.")</span></a>";
                $child .= Kategorije::checkChildSvi($row['catID']);
                $child .= '</div>';

        }
        return $child;
    }
    function populateCatSvi($catID){
        global $smarty, $conn;
        $sql="select * from categories  where parent =$catID order by catID";
        $result = $conn->Execute($sql);
        $sql2 = "select * from categories where parent =$catID order by catID " ;
        $mainCat = mysql_num_rows(mysql_query($sql));
        $kat .="";
        $kat .= "<table style='border:#ececec solid 1px;background-color:#eeecce'><tr>";
        while ($row=$result->FetchRow()) {
            $catID = $row['catID'];

            $sqlcount = "select SQL_CALC_FOUND_ROWS i.itemID, c.catID, c.catName    from items i , categories c where i.itemID in(select  distinct(itemID) from cat_items where catID = $catID) group by itemName order by catName ";
            $resultCount = $conn->Execute($sqlcount);
            $sqlcount = "SELECT FOUND_ROWS() as total";
            $_result = mysql_query($sqlcount);
            $_row = mysql_fetch_array($_result, MYSQL_ASSOC);
            $izbroj = $_row['total'];
            foreach (array($catID) as $catID) {
                $id = $catID;
                if($catID == $_REQUEST['catID']){
                    $bold = "<b>";
                    $boldEnd = "</b>";
                }else{
                    $bold = "";
                    $boldEnd = "";
                }

                    $kat .="<td valign='top' width='250px'>";
                    $kat .= "<a href=\"".$HTTP_SERVER_VARS['SERVER_ADDR']."i2.php?tabid=".$_REQUEST['tabid']."&tabindex=".$_REQUEST['tabindex']."&portalid=".$_REQUEST['portalid']."&a=view&catID=".$row['catID']."\" >".$bold.$row['catName']."(".$izbroj.")".$boldEnd."</a>";
                    $kat .= Kategorije::checkChildSvi($catID);
                    $kat .="</td>";
                }
        }
        $kat .= '</tr></table>';
        return $kat;
    }

Odgovor na temu