İçerikleri sılamak [Hata nerede?]

Aşağıdaki kodu koydum, arkadaşların da yardımı ile.
Ancak en son öyküyü 3 defa tekrarlıyor.
Ne yaparsam son 3 öyküyü verir?

<?
	require("ayar.php");
	?>
	<?
					for($i=0;$i<3;$i++)
					{
		$basla = ($_GET['p'] * 3) - 3;
		$data=mysql_fetch_array(mysql_query("SELECT *  FROM oykuler WHERE icerik AND anasayfa='Y' ORDER BY tarih DESC LIMIT $basla,3"));
	?>
	<table width="234px" cellpadding="0" cellspacing="0" border="0">
	<tr>
		<td class="table_spacing_10"></td>
		<td valign="middle">	
				<table cellpadding="0" cellspacing="0" border="0">
					<tr><td style="border:1px solid #e0e0e0;background-color:white;padding:2px;"><a href="oyku_devami.php?<?echo"id=$data[id]"?>" title="<?echo stripslashes($data[baslik])?>">
					<img src="images.php?id=<?=$data[image1]?>"  width="100" height="75" alt="<?echo stripslashes($data[baslik])?>" /></a></td></tr>
				</table>
		</td>
		<td align="right">
				<font class="angebot_info"><a href="oyku_devami.php?<?echo"id=$data[id]"?>" title="<?echo stripslashes($data[baslik])?>"><?echo stripslashes($data[baslik])?></a></font>
				<br /><br />
				<font class="angebot_info"><a href="oyku_devami.php?<?echo"id=$data[id]"?>" title="<?echo stripslashes($data[baslik])?>"> <?echo stripslashes($data[yazar])?></a></font><br/>
				<font class="angebot_info"><a href="oyku_devami.php?<?echo"id=$data[id]"?>" title="<?echo stripslashes($data[baslik])?>"><?echo stripslashes($data[yayin])?></a></font><br/>
				<font class="angebot_preis"><a href="oyku_devami.php?<?echo"id=$data[id]"?>" title="<?echo stripslashes($data[baslik])?>"><?echo stripslashes($data[ytarihi])?></a></font>
				
		</td>
		<td class="table_spacing_10">&nbsp;</td>
	</tr>
	</table>

for döngüsünü kaldirirsaniz problem çözülür

Bu şekilde değiştirdim,
Şimdi sadece tek bir içerik veriyor, o da son öykü.

<meta http-equiv="Content-Type" content="text/html" charset="ISO-8859-9">
<table width="100%" cellpadding="0" cellspacing="0" border="0">
	<tr><td width="25%" style="border-right:1px solid #c4c4c4;">
	<div class="space_10px"></div>
<?
	require("ayar.php");
	?>
	<?
		$basla = ($_GET['p'] * 3) - 3;
		$data=mysql_fetch_array(mysql_query("SELECT *  FROM oykuler WHERE icerik AND anasayfa='Y' ORDER BY tarih DESC LIMIT $basla,3"));
	?>
	<table width="234px" cellpadding="0" cellspacing="0" border="0">
	<tr>
		<td class="table_spacing_10"></td>
		<td valign="middle">	
				<table cellpadding="0" cellspacing="0" border="0">
					<tr><td style="border:1px solid #e0e0e0;background-color:white;padding:2px;"><a href="oyku_devami.php?<?echo"id=$data[id]"?>" title="<?echo stripslashes($data[baslik])?>">
					<img src="images.php?id=<?=$data[image1]?>"  width="100" height="75" alt="<?echo stripslashes($data[baslik])?>" /></a></td></tr>
				</table>
		</td>
		<td align="right">
				<font class="angebot_info"><a href="oyku_devami.php?<?echo"id=$data[id]"?>" title="<?echo stripslashes($data[baslik])?>"><?echo stripslashes($data[baslik])?></a></font>
				<br /><br />
				<font class="angebot_info"><a href="oyku_devami.php?<?echo"id=$data[id]"?>" title="<?echo stripslashes($data[baslik])?>"> <?echo stripslashes($data[yazar])?></a></font><br/>
				<font class="angebot_info"><a href="oyku_devami.php?<?echo"id=$data[id]"?>" title="<?echo stripslashes($data[baslik])?>"><?echo stripslashes($data[yayin])?></a></font><br/>
				<font class="angebot_preis"><a href="oyku_devami.php?<?echo"id=$data[id]"?>" title="<?echo stripslashes($data[baslik])?>"><?echo stripslashes($data[ytarihi])?></a></font>
				
		</td>
		<td class="table_spacing_10">&nbsp;</td>
	</tr>
	</table>
	<div class="space_5px"></td>
	<td width="25%" style="border-right:1px solid #c4c4c4;">
	<div class="space_10px"></div>
	
	<div class="space_5px"></tr><tr></tr>
	</table>

Merhaba, Birde bunu denermisiniz?
Tabloları döndürürken kayma filan olabilir belki.Onu sonradan duzenleyebiliriz.En azından son 3 veriyi bu sekilde cekebileceginize inanıyorum.Denedikten sonra bilgi verirseniz duruma gore hataları duzenleriz.




<meta http-equiv="Content-Type" content="text/html" charset="ISO-8859-9">
<table width="100%" cellpadding="0" cellspacing="0" border="0">
<tr><td width="25%" style="border-right:1px solid #c4c4c4;">
<div class="space_10px"></div>
<?
require("ayar.php");
$baglan = mysql_query("select * from oykuler where icerik and anasaya='Y' order by id desc limit 0,3");
while ($data = mysql_fecth_array($baglan)) {?>

<table width="234px" cellpadding="0" cellspacing="0" border="0">
<tr>
<td class="table_spacing_10"></td>
<td valign="middle">
<table cellpadding="0" cellspacing="0" border="0">
<tr><td style="border:1px solid #e0e0e0;background-color:white;padding:2px;"><a href="oyku_devami.php?<?echo"id=$data[id]"?>" title="<?echo stripslashes($data[baslik])?>">
<img src="images.php?id=<?=$data[image1]?>" width="100" height="75" alt="<?echo stripslashes($data[baslik])?>" /></a></td></tr>
</table>
</td>
<td align="right">
<font class="angebot_info"><a href="oyku_devami.php?<?echo"id=$data[id]"?>" title="<?echo stripslashes($data[baslik])?>"><?echo stripslashes($data[baslik])?></a></font>
<br /><br />
<font class="angebot_info"><a href="oyku_devami.php?<?echo"id=$data[id]"?>" title="<?echo stripslashes($data[baslik])?>"> <?echo stripslashes($data[yazar])?></a></font><br/>
<font class="angebot_info"><a href="oyku_devami.php?<?echo"id=$data[id]"?>" title="<?echo stripslashes($data[baslik])?>"><?echo stripslashes($data[yayin])?></a></font><br/>
<font class="angebot_preis"><a href="oyku_devami.php?<?echo"id=$data[id]"?>" title="<?echo stripslashes($data[baslik])?>"><?echo stripslashes($data[ytarihi])?></a></font>
</td>
<td class="table_spacing_10">&nbsp;</td>
</tr>
</table>
<? } ?>

<?
	require("ayar.php");
	?>
	<?
		$basla = ($_GET['p'] * 3) - 3;
		$data=mysql_fetch_array(mysql_query("SELECT *  FROM oykuler WHERE icerik AND anasayfa='Y' ORDER BY tarih DESC LIMIT $basla,3"));
					for($i=0;$i<3;$i++)
					{
	?>
	<table width="234px" cellpadding="0" cellspacing="0" border="0">
	<tr>
		<td class="table_spacing_10"></td>
		<td valign="middle">	
				<table cellpadding="0" cellspacing="0" border="0">
					<tr><td style="border:1px solid #e0e0e0;background-color:white;padding:2px;"><a href="oyku_devami.php?<?echo"id=$data[id]"?>" title="<?echo stripslashes($data[baslik])?>">
					<img src="images.php?id=<?=$data[image1]?>"  width="100" height="75" alt="<?echo stripslashes($data[baslik])?>" /></a></td></tr>
				</table>
		</td>
		<td align="right">
				<font class="angebot_info"><a href="oyku_devami.php?<?echo"id=$data[id]"?>" title="<?echo stripslashes($data[baslik])?>"><?echo stripslashes($data[baslik])?></a></font>
				<br /><br />
				<font class="angebot_info"><a href="oyku_devami.php?<?echo"id=$data[id]"?>" title="<?echo stripslashes($data[baslik])?>"> <?echo stripslashes($data[yazar])?></a></font><br/>
				<font class="angebot_info"><a href="oyku_devami.php?<?echo"id=$data[id]"?>" title="<?echo stripslashes($data[baslik])?>"><?echo stripslashes($data[yayin])?></a></font><br/>
				<font class="angebot_preis"><a href="oyku_devami.php?<?echo"id=$data[id]"?>" title="<?echo stripslashes($data[baslik])?>"><?echo stripslashes($data[ytarihi])?></a></font>
		</td>
		<td class="table_spacing_10">&nbsp;</td>
	</tr>
	</table>

Bu şekilde deneyin.

Son bir öyküyü 3 defa tekrarladı...

$_GET['p'] 'nin sayısal degeri ne ?
ve
eğer sayfalama ya da farklı bir degerle kullanım şekli yoksa sorguyu

"SELECT * FROM oykuler WHERE icerik AND anasayfa='Y' ORDER BY tarih DESC LIMIT 3"
şeklinde değiştiriniz.

Şu hatayı verdi:
Fatal error: Call to undefined function mysql_fecth_array() in /www/apserv/oykulerim/1.php on line 10

10'cu satır şu yazıdığınız satır:
while ($data = mysql_fecth_array($baglan)) {?>

Birde şu şekil daha iyi:

$basla = ($_GET['p'] * 3) - 3;
$data=mysql_fetch_array(mysql_query("SELECT * FROM oykuler WHERE icerik AND anasayfa='Y' ORDER BY id DESC LIMIT $basla,3"));

Çünkü dikkat ederseniz sayfalama var, onu da bozmak istemiyorum.

$_GET['p'] 'nin sayısal değeri nedir bilmiyorum valla.

Sayfalama var evet.