• 13-05-2010, 20:35:20
    #1
    Mrb Haber Ekleme Çıkarma İle İlgili Bir Kod Yazdım Ama ?id=x ne olursa olsun sürekli hep aynı haberi gösteriyor.Yardımcı Olursanız Sevinirim.


    <?php 
    include("includes/connect.php");     
    ?> 
    <table id="slidertb" cellpadding="0" cellspacing="0">
    					<tr>
    						<td height="129"><img src="images/altbaslik.jpg" width="967" height="127" /> </td>
    					</tr>
    			  </table>
    				<table width="100%" cellpadding="0" cellspacing="0" id="ortatablo">
    					<tr>
    						<td width="209" height="280" id="leftcolum"><table id="icerikler" cellspacing="0" cellpadding="0">
                              <tbody>
                                <tr>
                                  <td id="icerikbg_top" colspan="2"><span class="sayfabaslik">Kösreli Belediyesi Haberler</span></td>
                                </tr>
                                <tr>
                                  <td width="225" height="226" id="tdsol"><table width="86%" cellpadding="0" cellspacing="0" class="kutucuk">
                                      <tbody>
                                        <tr>
                                          <td class="box" colspan="2">Haber Başlıkları</td>
                                        </tr>
                                <?php 
    
      
    $SQL1 = "SELECT * FROM haber order by id desc";		
    $sorgu1=mysql_query($SQL1,$connect);
    
    while($record1=mysql_fetch_array($sorgu1))
    {
    		 
    	$id=$record1["id"];
    	$baslik=$record1["baslik"];			 
    	$tarih=$record1["tarih"];
            $detay=$record1["detay"]						  
    	
    ?>
    									
    									<tr>
                                          <td class="boxcenter" colspan="2">            <a href="<? echo "?id=$id";?>" class="linkdetay style8">  <?php echo "$baslik";?></a>
                                        </tr>
                                                         <?
    			  }
    			  ?>
    									
    									<tr>
                                          <td class="boxleft">&nbsp;</td>
                                          <td class="boxright">&nbsp;</td>
                                        </tr>
                                      </tbody>
                                    </table>
                                      <div>&nbsp;</div>
                                  <div>&nbsp;</div></td>
                                  <td width="899" id="tdsag"><div class="top"></div>
                                    <div class="center">
                                        <table cellspacing="0" cellpadding="0" width="718" align="left" 
    border="0">
                                          <tbody>
                                            <tr bgcolor="#efefef">
                                              <td bgcolor="#FFFFFF">
    										  <table width="102%" height="92" border="0" cellpadding="5" cellspacing="1">
    										    <tr>
                                                  <td height="24" bgcolor="#FFFFFF" class="baslikgri"><table width="100%" border="0" cellspacing="0" cellpadding="0">
                                                      <tr>
                                                        <td width="16%" valign="top"><? if($resim){?>
                                                            <img src="upload/haber/<?=$resim?>" width="120" hspace="3" vspace="3" align="left" class="border" />
                                                            <?
    				  }else{?>
                                                            <img src="images/logo.jpg" width="120" height="120" hspace="3" vspace="3" align="left" class="border" />
                                                            <? } ?>
                                                        </td>
                                                        <td width="84%" valign="top" bgcolor="#FFFFFF" class="baslik2"><table width="96%" border="0" align="center" cellpadding="0" cellspacing="0">
                                                            <tr>
                                                              <td class="baslik2"><span class="style13">
                                                                <?=$baslik?>
                                                              </span></td>
                                                            </tr>
                                                            <tr>
                                                              <td><span class="style style10 style11">
                                                                <?=$detay?>
                                                                <?=$tarih?>
                                                              </span></td>
                                                            </tr>
                                                        </table></td>
                                                      </tr>
                                                    </table>
                                                  <a href="<? echo "?id=$id";?>" class="linktru"></a></td>
    									        </tr>
                                                  <tbody>
                                                    <tr bgcolor="#ffffff">
                                                      <td>&nbsp;</td>
                                                    </tr>
                                                  </tbody>
                                              </table></td>
                                            </tr>
                                          </tbody>
                                      </table>
                                    </div></td>
                                </tr>
                              </tbody>
    					    </table></td>
    					</tr>
    				</table>
    
    
        
        
        
        
    
    
    
    
    			</div>
    			</td>
    		</tr>
    		<tr>
    			<td>
    			<img alt="LocalHost Çalışmas" src="images/main_bottom.gif" /></td>
    		</tr>
    		<tr>
    			<td>
    			<table cellpadding="0" cellspacing="0" width="100%">
    				<tr>
    					<td width="0%" height="13">&nbsp;					</td>
    					<td width="100%">Copyright © 2009  <span class="style5">LocalHost Çalışması</span>  </td>
    					<br>
    </tr>
    			</table>
    			</td>
    		</tr><b>
    </b>
    <tr>
    			<td>
    			<table cellpadding="0" cellspacing="0" width="100%">
    				<tr>
    				  <td>                  
    			  </tr>
    			</table>
    			</td>
    		</tr>
    	</table>
    <script type="text/javascript">
    var gaJsHost = (("https:" == document.location.protocol) ? "https://ssl." : "http://www.");
    document.write(unescape("%3Cscript src='" + gaJsHost + "google-analytics.com/ga.js' type='text/javascript'%3E%3C/script%3E"));
    </script>
        </form>
    </body>
    
    <meta http-equiv="content-type" content="text/html;charset=utf-8">
    </html>
  • 13-05-2010, 21:08:08
    #2
    Bu şekilde dene bakalım sorun düzelcek mi.


    <?php
    include("includes/connect.php");    
    ?>
    
                    <table width="100%" cellpadding="0" cellspacing="0" id="ortatablo">
                        <tr>
                            <td width="209" height="280" id="leftcolum"><table id="icerikler" cellspacing="0" cellpadding="0">
                              <tbody>
                                <tr>
                                </tr>
                                <tr>
                                  <td width="225" height="226" id="tdsol"><table width="86%" cellpadding="0" cellspacing="0" class="kutucuk">
                                      <tbody>
                                        <tr>
                                          <td class="box" colspan="2">Haber Başlıkları</td>
                                        </tr>
                                <?php 
    
      
    $SQL1 = "SELECT * FROM haber WHERE id='".$_GET["id"]."' order by id desc";        
    $sorgu1=mysql_query($SQL1,$connect);
    
    while($record1=mysql_fetch_array($sorgu1))
    {
             
        $id=$record1["id"];
        $baslik=$record1["baslik"];             
        $tarih=$record1["tarih"];
            $detay=$record1["detay"];                          
        
    ?>
                                        
                                        <tr>
                                          <td class="boxcenter" colspan="2">            <a href="<? echo "?id=$id";?>" class="linkdetay style8">  <?php echo "$baslik&nbsp;&nbsp;";?></a>
                                        </tr>
                                                         <?
                  }
                  ?>
                                        
                                        <tr>
                                          <td class="boxleft">&nbsp;</td>
                                          <td class="boxright">&nbsp;</td>
                                        </tr>
                                      </tbody>
                                    </table>
                                      <div>&nbsp;</div>
                                  <div>&nbsp;</div></td>
                                  <td width="899" id="tdsag"><div class="top"></div>
                                    <div class="center">
                                        <table cellspacing="0" cellpadding="0" width="718" align="left" 
    border="0">
                                          <tbody>
                                            <tr bgcolor="#efefef">
                                              <td bgcolor="#FFFFFF">
                                              <table width="102%" height="92" border="0" cellpadding="5" cellspacing="1">
                                                <tr>
                                                  <td height="24" bgcolor="#FFFFFF" class="baslikgri"><table width="100%" border="0" cellspacing="0" cellpadding="0">
                                                      <tr>
                                                        <td width="16%" valign="top"><? if($resim){?>
                                                            <img src="upload/haber/<?=$resim?>" width="120" hspace="3" vspace="3" align="left" class="border" />
                                                            <?
                      }else{?>
                                                            
                                                            <? } ?>
                                                        </td>
                                                        <td width="84%" valign="top" bgcolor="#FFFFFF" class="baslik2"><table width="96%" border="0" align="center" cellpadding="0" cellspacing="0">
                                                            <tr>
                                                              <td class="baslik2"><span class="style13">
                                                                <?=$baslik?>
    
                                                              </span></td>
                                                            </tr>
                                                            <tr>
                                                              <td><span class="style style10 style11">
                                                                
                                                                <?=$tarih?>
    <span class="metin" id="xmhaberspot"></span>
    
                                                                
                                <tr>
                                  <td class="centerbottom">
                                  
                                  <table width="558" border="0">
                                    <tr>
                                      <td width="107"><? if($resim){?>
                                          <img src="upload/habermin/<?=$resim?>" class="resimborder" />
                                          <? } else {?>
                                          <img src="images/nto.jpg" class="resimborder" />
                                          <? } ?>
                                      </td>
                                      <td width="441"><span class="baslik"  id="xmhaberbaslik">
                                        <?=$baslik?>
                                        </span><br />
                                        <span class="metin" id="xmhaberspot"><? echo "$detay...";?></span><br />
                                        <br />
                                        <span class="tarih"><a href="haber.php?haber_id=<?=$haber_id?>" class="linksiyah">Devamı</a> </span></td>
                                    </tr>  
                                                              </span></td>
                                                            </tr>
                                                        </table></td>
                                                      </tr>
                                                    </table>
                                                  <a href="<? echo "?id=$id";?>" class="linktru"></a></td>
                                                </tr>
                                                  <tbody>
                                                    <tr bgcolor="#ffffff">
                                                      <td>&nbsp;</td>
                                                    </tr>
                                                  </tbody>
                                              </table></td>
                                            </tr>
                                          </tbody>
                                      </table>
                                    </div></td>
                                </tr>
                              </tbody>
                            </table></td>
                        </tr>
                    </table>
    
    
        
        
        
        
    
    
    
    
                </div>
                </td>
            </tr>
            <tr>
                <td>
                <img alt="Local Host Çalışması" src="images/main_bottom.gif" /></td>
            </tr>
            <tr>
                <td>
                <table cellpadding="0" cellspacing="0" width="100%">
                    <tr>
                        <td width="0%" height="13">&nbsp;                    </td>
                        <td width="100%">Copyright © 2009  <span class="style5">Localhost çalışmam</span>  </td>
                        <br>
    </tr>
                </table>
                </td>
            </tr><b>
    </b>
    <tr>
                <td>
                <table cellpadding="0" cellspacing="0" width="100%">
                    <tr>
                      <td>                  
                  </tr>
                </table>
                </td>
            </tr>
        </table>
    <script type="text/javascript">
    var gaJsHost = (("https:" == document.location.protocol) ? "https://ssl." : "http://www.");
    document.write(unescape("%3Cscript src='" + gaJsHost + "google-analytics.com/ga.js' type='text/javascript'%3E%3C/script%3E"));
    </script>
        </form>
    </body>
    
    <meta http-equiv="content-type" content="text/html;charset=utf-8">
    </html>
  • 13-05-2010, 21:33:31
    #3
    Tesekur Ederim ama Sorunum düzelmedi , Kodları Düzelttim Tekrar Alıp Bakarsanız

    ?=$detay?> şu kodu nasıl yaparsam yapim hangi habere girsem tek bir haber çıkıyor
  • 13-05-2010, 22:52:40
    #4
    $gelenid = $_GET['id'];
    $SQL1 = "SELECT * FROM haber WHERE id = '$gelenid' order by id desc";
    bu düzeltmeyi yapmamışsınız gibi görünüyor
    ayrıca
    <a href="<? echo "?id=$id";?>" class="linktru"></a></td> 
    bu satırı
    <a href="<? echo "?id=$gelenid";?>" class="linktru"></a></td>
    yapmayı deneyin sorun olmaması lazım