0
Kayıt Ol

Bas ve Yana Geç

2

●

482

  • 18-11-2008, 17:19:43
    #1
    tolgay007
    tolgay007
    Arkadaşlar bi önceki konumda sordum amabaşlık afrklı olduğu için karıştı şimdi bakın

    Filtre 2001 || Trk Filtre Fabrikası burda hava kategorisindeki filterleri sıralıyor ama gördüğünüz gibi üst üste sıralamış ben mesela

    Macera Oyunları | 1 | Oyunları oyun oyunu oyunlar

    burda gördüğünüz gibi bunun aynısı gibi bişey yapmak istiyorum yani yanyana dizsin mesela ilk satırda 4 göstersin sonra bi aşağı geçsin 4 bassın falan yani inş. anlatabilmişimdir yani ben doğru düzgün listelemesini istiyorum kısaca kaynak kodlar aşağıda nasıl halledebilirim ?

    <?php

$db = mysql_connect('localhost','tolgay','ttoklar') or die ('Veritabanına Bağlanılamadı');

mysql_select_db('filter',$db);

$sorgu = mysql_query("select * from filtre where tipi='Hava' ORDER BY id DESC   ");





?>
<style type="text/css">
<!--
body {
    background-image: url();
    background-repeat: repeat-x;
}
a {
    font-family: Geneva, Arial, Helvetica, sans-serif;
    color: #FFFFFF;
}
a:visited {
    color: #FFFFFF;
}
a:hover {
    color: #000000;
}
a:active {
    color: #000000;
}
#Layer1 {
    position:absolute;
    left:27px;
    top:84px;
    width:229px;
    height:110px;
    z-index:1;
}
#Layer2 {
    position:absolute;
    left:369px;
    top:50px;
    width:285px;
    height:73px;
    z-index:2;
}
#Layer3 {
    position:absolute;
    left:299px;
    top:89px;
    width:216px;
    height:39px;
    z-index:3;
}
#Layer4 {
    position:absolute;
    left:710px;
    top:84px;
    width:110px;
    height:108px;
    z-index:3;
    background-image: url(filter2001.gif);
}
#Layer5 {
    position:absolute;
    left:27px;
    top:204px;
    width:823px;
    height:32px;
    z-index:4;
}
#Layer6 {
    position:absolute;
    left:65px;
    top:213px;
    width:101px;
    height:21px;
    z-index:4;
}
#Layer7 {
    position:absolute;
    left:335px;
    top:213px;
    width:101px;
    height:21px;
    z-index:5;
}
#Layer8 {
    position:absolute;
    left:651px;
    top:213px;
    width:102px;
    height:23px;
    z-index:6;
}
#Layer9 {
    position:absolute;
    left:220px;
    top:261px;
    width:436px;
    height:297px;
    z-index:7;
    background-image: url(alt_alan1.jpg);
}
#Layer10 {
    position:absolute;
    left:145px;
    top:269px;
    width:538px;
    height:391px;
    z-index:7;
    background-image: url(sagbg2.gif);
}
#Layer11 {
    position:absolute;
    left:490px;
    top:461px;
    width:393px;
    height:303px;
    z-index:7;
    background-image: url(sagbg3.gif);
}
#Layer12 {
    position:absolute;
    left:24px;
    top:465px;
    width:319px;
    height:295px;
    z-index:8;
    background-image: url(solbg.gif);
    overflow: visible;
}
#Layer13 {
    position:absolute;
    left:215px;
    top:236px;
    width:417px;
    height:282px;
    z-index:9;
    background-image: url(alt_alan2.jpg);
}
#Layer14 {
    position:absolute;
    left:905px;
    top:15px;
    width:108px;
    height:767px;
    z-index:10;
    background-image: url(sagyeni.gif);
}
#Layer15 {
    position:absolute;
    left:26px;
    top:273px;
    width:100px;
    height:93px;
    z-index:11;
}
#Layer16 {
    position:absolute;
    left:906px;
    top:711px;
    width:102px;
    height:70px;
    z-index:12;
}
#Layer17 {
    position:absolute;
    left:25px;
    top:783px;
    width:874px;
    height:25px;
    z-index:12;
}
#Layer18 {
    position:absolute;
    left:153px;
    top:269px;
    width:131px;
    height:98px;
    z-index:12;
}
#Layer19 {
    position:absolute;
    left:129px;
    top:272px;
    width:314px;
    height:84px;
    z-index:12;
}
#Layer20 {
    position:absolute;
    left:451px;
    top:270px;
    width:2px;
    height:489px;
    z-index:13;
    background-color: #CCCCCC;
}
#Layer21 {
    position:absolute;
    left:27px;
    top:272px;
    width:102px;
    height:95px;
    z-index:14;
}
#Layer22 {
    position:relative;
    left:4px;
    top:4px;
    width:1019px;
    height:815px;
    z-index:15;
}
#Layer23 {
    position:absolute;
    left:21px;
    top:272px;
    width:434px;
    height:491px;
    z-index:14;
}
.style5 {font-family: Arial, Helvetica, sans-serif}
#Layer24 {
    position:absolute;
    left:16px;
    top:241px;
    width:438px;
    height:28px;
    z-index:15;
    background-image: url(urunen2.gif);
}
#Layer25 {
    position:absolute;
    left:16px;
    top:270px;
    width:2px;
    height:488px;
    z-index:16;
    background-image: url(orta.gif);
}
#Layer26 {
    position:absolute;
    left:17px;
    top:757px;
    width:435px;
    height:2px;
    z-index:17;
    background-image: url(alttablo.gif);
}
#Layer27 {
    position:absolute;
    left:456px;
    top:271px;
    width:444px;
    height:482px;
    z-index:18;
}
#Layer28 {
    position:absolute;
    left:468px;
    top:281px;
    width:201px;
    height:183px;
    z-index:19;
}
#Layer29 {
    position:absolute;
    left:682px;
    top:281px;
    width:201px;
    height:183px;
    z-index:20;
}
#Layer30 {
    position:absolute;
    left:577px;
    top:470px;
    width:210px;
    height:184px;
    z-index:21;
}
#Layer31 {
    position:absolute;
    left:469px;
    top:242px;
    width:438px;
    height:28px;
    z-index:22;
    background-image: url(urunen2.gif);
}
#Layer32 {
    position:absolute;
    left:456px;
    top:242px;
    width:438px;
    height:28px;
    z-index:22;
    background-image: url(tumfilter.gif);
}
#Layer33 {
    position:absolute;
    left:575px;
    top:652px;
    width:248px;
    height:101px;
    z-index:23;
}

.myinputstyle {
    border: 1px solid #dfe6ea;
    font-family: tahoma, helvetica, sans-serif;
    font-style: normal;
    font-size: 13px;
    color: #777777;
    height:18px;
    background-color: #FFFFFF;
    background-image: url(input_bg.png);
    background-repeat: repeat-x;
    background-position: bottom;
}
.mybuttonstyle {
    border: 1px solid #dfe6ea;
    font-family: tahoma, helvetica, sans-serif;
    font-style: normal;
    font-size: 13px;
    color: #777777;
    height:18px;
    background-color: #FFFFFF;
    background-image: url(input_bg.png);
    background-repeat: repeat-x;
    background-position: bottom;
}
#Layer34 {
    position:absolute;
    left:218px;
    top:186px;
    width:37px;
    height:28px;
    z-index:24;
}
#Layer35 {
    position:absolute;
    left:23px;
    top:258px;
    width:866px;
    height:487px;
    z-index:18;
}
#apDiv1 {
    position:absolute;
    left:25px;
    top:263px;
    width:863px;
    height:484px;
    z-index:11;
}

-->
</style><title>Filtre 2001 || T&uuml;rk Filtre Fabrikası</title>
<script type="text/JavaScript">
<!--
function MM_findObj(n, d) { //v4.01
  var p,i,x;  if(!d) d=document; if((p=n.indexOf("?"))>0&&parent.frames.length) {
    d=parent.frames[n.substring(p+1)].document; n=n.substring(0,p);}
  if(!(x=d[n])&&d.all) x=d.all[n]; for (i=0;!x&&i<d.forms.length;i++) x=d.forms[i][n];
  for(i=0;!x&&d.layers&&i<d.layers.length;i++) x=MM_findObj(n,d.layers[i].document);
  if(!x && d.getElementById) x=d.getElementById(n); return x;
}

function MM_setTextOfTextfield(objName,x,newText) { //v3.0
  var obj = MM_findObj(objName); if (obj) obj.value = newText;
}
//-->
</script>
<script src="Scripts/AC_RunActiveContent.js" type="text/javascript"></script>

<div id="Layer1"><img src="caniss.png" width="300" height="110" /></div>
<div id="Layer2">
  <form  method="get" action="ara.php">
    <p>&nbsp;</p>
    <p>&nbsp;</p>
    <p>
      <label for="textfield"></label>
      <input name="ara" type="text" class="myinputstyle" id="ara" onClick="MM_setTextOfTextfield('ara','','')" value="Ara...">
      <label for="Submit"></label>
      <input name="Submit" type="submit" class="mybuttonstyle" id="Submit" value="Ara">
    </p>
    <p>&nbsp;</p>
  </form>
</div>
<div id="Layer4"></div>
<div id="Layer6">
  <script type="text/javascript">
AC_FL_RunContent( 'codebase','http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=5,0,0,0','name','asas','width','100','height','22','title','kimiz','id','asas','src','kimiz','quality','high','pluginspage','http://www.macromedia.com/shockwave/download/index.cgi?P1_Prod_Version=ShockwaveFlash','movie','kimiz' ); //end AC code
</script><noscript>
<object classid="clsid:D27CDB6E-AE6D-11cf-96B8-444553540000" codebase="http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=5,0,0,0" name="asas" width="100" height="22" id="asas" title="kimiz">
  <param name="movie" value="kimiz.swf">
  <param name="quality" value="high">
  <embed src="kimiz.swf" width="100" height="22" quality="high" pluginspage="http://www.macromedia.com/shockwave/download/index.cgi?P1_Prod_Version=ShockwaveFlash" type="application/x-shockwave-flash" name="asas" ></embed>
</object>
</noscript>
</div>
<div id="Layer7">
  <script type="text/javascript">
AC_FL_RunContent( 'codebase','http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=7,0,19,0','width','100','height','22','title','i8i8','src','urun','quality','high','pluginspage','http://www.macromedia.com/go/getflashplayer','movie','urun' ); //end AC code
</script><noscript><object classid="clsid:D27CDB6E-AE6D-11cf-96B8-444553540000" codebase="http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=7,0,19,0" width="100" height="22" title="ı8ı8">
    <param name="movie" value="urun.swf" />
    <param name="quality" value="high" />
    <embed src="urun.swf" quality="high" pluginspage="http://www.macromedia.com/go/getflashplayer" type="application/x-shockwave-flash" width="100" height="22"></embed>
  </object>
</noscript></div>
<div id="Layer8">
  <script type="text/javascript">
AC_FL_RunContent( 'codebase','http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=5,0,0,0','width','100','height','22','src','ilet','quality','high','pluginspage','http://www.macromedia.com/shockwave/download/index.cgi?P1_Prod_Version=ShockwaveFlash','bgcolor','','movie','ilet' ); //end AC code
</script><noscript>
<object classid="clsid:D27CDB6E-AE6D-11cf-96B8-444553540000" codebase="http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=5,0,0,0" width="100" height="22">
  <param name="BGCOLOR" value="">
  <param name="movie" value="ilet.swf">
  <param name="quality" value="high">
  <embed src="ilet.swf" quality="high" pluginspage="http://www.macromedia.com/shockwave/download/index.cgi?P1_Prod_Version=ShockwaveFlash" type="application/x-shockwave-flash" width="100" height="22" ></embed>
</object>
</noscript></div>
<div id="Layer14"></div>


<table width="902" height="768" border="1" cellpadding="5" cellspacing="10" background="tablebg.gif">

  <tr>
 
    <td width="868" bordercolor="#000000" background="tablebg.gif" scope="col"><p>&nbsp;</p>
      <p>&nbsp;</p>
      <p>&nbsp;</p>
     <br />
      &nbsp;
      <br />
     <br />&nbsp; <table width="99%" height="520" border="0" align="left" cellpadding="1" cellspacing="1">
       <tr>
         <td width="100%" height="516" valign="baseline" scope="row" ><table width="157" height="209" border="1" cellpadding="5" cellspacing="10" bgcolor="#FFFFCC">
           <?php
           while ($data=mysql_fetch_array($sorgu))
           {
           ?>
           <tr>
             <th height="139" bgcolor="#FFFFFF" scope="row"><a href=urun.php?id=<?php echo "".$data[id].""; ?>><img height=139 src=fotolar/<?php echo "".$data[resmi].""; ?> ></a></th>
           </tr>
           <tr>
             <th bgcolor="#FFFFFF" scope="row"><font face=Arial><b><center><?php echo "".$data[kod].""; ?></center></b></font></th>
           </tr><?php } ?>
         </table></td>
       </tr>
     </table>
    <p>&nbsp;</p></td>
  </tr>
</table>
  • 18-11-2008, 18:38:10
    #2
    ChuckyFun
    ChuckyFun 
               <?php 
           while ($data=mysql_fetch_array($sorgu)) 
           { 
           ?> 
           <tr> 
             <th height="139" bgcolor="#FFFFFF" scope="row"><a href=urun.php?id=<?php echo "".$data[id].""; ?>><img height=139 src=fotolar/<?php echo "".$data[resmi].""; ?> ></a></th> 
           </tr> 
           <tr> 
             <th bgcolor="#FFFFFF" scope="row"><font face=Arial><b><center><?php echo "".$data[kod].""; ?></center></b></font></th> 
           </tr><?php } ?>
    Bu kodlarını şöyle değiştir

    <?php
    $sutun = 4;
    echo "<tr>";
    while ($data=mysql_fetch_array($sorgu)) {
        echo "<td width=100%>";
        echo "<table border=0 width=100% cellpadding=0 cellspacing=0><tr>";
        echo "<th height=\"139\" bgcolor=\"#FFFFFF\" scope=\"row\"><a href=urun.php?id=".$data[id]."><img height=139 src=fotolar/".$data[resmi]."></a></th>";
        echo "<tr>";
        echo "<th bgcolor=\"#FFFFFF\" scope=\"row\"><font face=Arial><b><center>".$data[kod]."</center></b></font></th>";
        echo "</tr></table>";
        echo "</td>";
        $sutun++;
        if ($sutun == "4") {
        echo "</tr><tr>";
        $sutun=0;
        }
    }
?>
    Çalışması gerekiyor, 4 lü sütunlar halinde sıralar veriyi
  • 19-11-2008, 14:50:55
    #3
    tolgay007
    tolgay007
    çok sağol işime yaradı

    Edit:Yeni filtre ekleyince alta atmadı ya <br> de attım genede olmadı

    Tekrar Edit : Hatanın nerde olduğunu anladım başta 4 vermişisin sütuna sonra 4 e gelince artır demişisn karışıtrmışsın 0 değerini verince oldu sağol