Tek Basıyor

Arkadaşlar bi kategorideki tüm ürünleri listeliyecem daha sayfalama yapmadan bi önce hepsini çekeyim dedim yani daha count kullanmadım ama nedense hep ekrana 1 tane basıyor lımıt olsada olmasada 5 te olsa 2 de olsa 1 tane basıyor kaynak kodu aşağıda nedendir ?

   <?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' LIMIT 2 ");

while ($bas=mysql_fetch_array($sorgu)) {



?>
<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;
}

-->
</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"><table width="182" height="174" border="1" cellpadding="5" cellspacing="10" bgcolor="#FFFFCC">
      <tr>
        <th height="141" bgcolor="#FFFFFF" scope="row"><a href=urun.php?id=<?php echo "".$bas[id].""; ?>><img height='141' src=fotolar/<?php echo "".$bas[resmi].""; ?>></a></th>
      </tr>
    </table>
      <table width="182" border="1" cellpadding="5" cellspacing="10" bordercolor="#000000" bgcolor="#FFFFCC">
        <tr>
          <th width="148" height="30" bgcolor="#FFFFFF" scope="row"><?php echo "".$bas[kod].""; ?></th>
        </tr>
      </table></td>
  </tr>
</table>

<?php }?>

Arkadşlar hiç while ı yanlış yere koydun demeyin benimde aklıma geldi düzellttim ama gene tek bastı www.chatlok.com/firma/allairfilter.php

select * from filtre where tipi='Hava' ORDER BY id DESC LIMIT 2

bu şekilde dene.

az önce denedim ama tekrar bakayım olmamıştı ilk denediğimde

edit:Olmadı

çalışmaması imkansız : )
ftp veya localhost seçeneklerini kullan kodu çalıştırmak için.
ben de xamp üzerinde (loc.) sürekli while döngülerinde hata alıyorum ( :
arada bir sorun yaptığı oluyor.

zaten ftp den çalıştırıyorum bak Filtre 2001 || Trk Filtre Fabrikası

ya veritabanında birden fazla ürün kayıtlı değil, ya da ... aklıma birşey gelmiyor ( :

yok ekli ya valla pc mühendisine sordum oda çözemedi

Edit:Allah kahretsin diyorum dünden beri kafa patlatıyorum meğersem db de 1 tane hava ekliymiş

Arkadaşlar şimdi basıyor ancak yamuk yumuk oluyor while döngüsünü nerde kaparsam düzelir o sorun ? bakın

Filtre 2001 || Trk Filtre Fabrikası kaynak kod 1. mesajda