I need help on this PHP code


Posted on 16th Feb 2014 07:03 pm by admin

Hi everybody, I made some kind of mistake while editing the code below. As you see, at the 3 row my news are repetition of raw 2.
http://www.demirtepe.net/haber/index17.php

As a matter of fact, I had only 2 rows, but I needed to have more than 2 rows and tried to edit the code by myself. I finally managed to have 3 rows but it turned out as the repetition of raw 2. The original appearance of it was like this:
http://demirtepe.net/haber/index34.php


Below is the code:
Code: <?php
include("ayar.php");
$sqllist="select * from demirtepe where durum=0 order by id desc ";
mysql_query("SET NAMES 'utf8'");
$execute=mysql_query($sqllist);
$list =@ mysql_fetch_array($execute);
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Untitled Document</title>
<style type="text/css">
<!--
body {
margin-left: 0px;
margin-top: 0px;
margin-right: 0px;
margin-bottom: 0px;
}
a:link {
text-decoration: none;
color: #E05400;
}
a:visited {
text-decoration: none;
color: #E05400;
}
a:hover {
text-decoration: none;
color: #E05400;
}
a:active {
text-decoration: none;
color: #E05400;
}
img{border:none;}
-->
</style></head>

<body>

<table width="706" border="0" align="center">
<tr align="left" valign="top">
<td width="368" style="font-family:Verdana, Arial, Helvetica, sans-serif; font-size:12px;">
<h3 style="color:#E05400;"><strong><?php echo"$list[baslik]";?></strong></h3>

<?php

$metin = $list['ozet'];

$uzunluk = strlen($metin);

$sinir = 685;
if ($uzunluk> $sinir) {
$icerik = substr($metin,0,$sinir) . "&nbsp; <a href='haberdetay.php?id=$list[id]'><u>haberin devam&#305;</u> >></a>";
echo $icerik;
}

else
{
echo "$list[ozet]<br />&nbsp; <a href='haberdetay.php?id=$list[id]'><u>haberin devam&#305;</u> >></a>";
}
?>
<br />


&nbsp;</td>
<td width="328" align="right" valign="middle"><img src="<?php echo"$list[resim]";?>" width="315" height="238" /></td>
</tr>
</table>

<table width="704" border="0" align="center">
<tr>


<p> </p>
<?php


$sqllist="select * from demirtepe where id < $list[id] and durum=0 order by id desc limit 2 ";
$execute=mysql_query($sqllist);
mysql_query("SET NAMES 'utf8'");
while ($list2 =@ mysql_fetch_array($execute))
{


$metin = $list2['ozet'];

$uzunluk = strlen($metin);

$sinir = 80;
if ($uzunluk> $sinir) {
$icerik = substr($metin,0,$sinir) . "";
}



echo " <td width='154' height='115' valign='top'>
<a href='haberdetay.php?id=$list2[id]'> <img src='$list2[resim]' width='154' height='113' align='top' /> </a> </td>

<td width='214' valign='top'><span style='color:#E05400; font-family:Verdana, Arial, Helvetica, sans-serif; font-size:12px;'><b><a href='haberdetay.php?id=$list2[id]'>$list2[baslik]</a> </b></span><br /><a href='haberdetay.php?id=$list2[id]'><span style='color:#000000; font-family:Verdana, Arial, Helvetica, sans-serif; font-size:12px;'>$icerik</span></a> <span style='text-align:right; color:#E05400;'> <a href='haberdetay.php?id=$list2[id]'>>></a> </span></td>
<td></td>
";
}

?>

</tr>




<tr>


<p> </p>
<?php


$sqllist="select * from demirtepe where id < $list[id] and durum=0 order by id desc limit 2 ";
$execute=mysql_query($sqllist);
mysql_query("SET NAMES 'utf8'");
while ($list3 =@ mysql_fetch_array($execute))
{


$metin = $list3['ozet'];

$uzunluk = strlen($metin);

$sinir = 80;
if ($uzunluk> $sinir) {
$icerik = substr($metin,0,$sinir) . "";
}



echo " <td width='154' height='115' valign='top'>
<a href='haberdetay.php?id=$list3[id]'> <img src='$list3[resim]' width='154' height='113' align='top' /> </a> </td>

<td width='214' valign='top'><span style='color:#E05400; font-family:Verdana, Arial, Helvetica, sans-serif; font-size:12px;'><b><a href='haberdetay.php?id=$list3[id]'>$list3[baslik]</a> </b></span><br /><a href='haberdetay.php?id=$list3[id]'><span style='color:#000000; font-family:Verdana, Arial, Helvetica, sans-serif; font-size:12px;'>$icerik</span></a> <span style='text-align:right; color:#E05400;'> <a href='haberdetay.php?id=$list3[id]'>>></a> </span></td>
<td></td>
";
}

?>

</tr>












</table>
<table width="712" border="0" align="center">
<tr>
<td width="702" align="right"><a href="tumhaberler.php"><u>tüm haberleri görmek için tıklayın...</u></a></td>
</tr>
</table>


</body>
</html>

Thanks a lot for your help, I highly appreciate your helping on this.

No comments posted yet

Your Answer:

Login to answer
309 Like 22 Dislike
Previous forums Next forums
Other forums

the problem with str_replace
$str="hahahahahahahahahahahahahaha";
$nn=1;
$str=str_replace('ha','MyGod',$str,$nn);

PHP not creating file.
Its supposed to create a .ini file in the /scriptfiles/users/ with the name they entered into the fi

Sending UDP Raw socket
I truly need help on this. I am trying to write a test program that simulate a network environment

Redistributing dependent dlls
Hai all ,

I have created an application in VC++ using VS2008 in a development machine which r

More pug propaganda.
http://www.youtube.com/watch?v=8Kkrmubsgf8

The commercial is definitely worth watching pug aw

Retreiving objects from Sessions
Hi all,

I am getting really frustrated with storing and retreiving objects from a session. Bu

Select Rows as Columns..
is there a way to select COLUMN_NAME from user_tab_columns where table_name='TABLENAME';
and ha

how to easy edit text, with box? Help.
Hi.
I have a little problem. I'm doing a webpage for my aunt and I would like to make it as easy

SOAP Issue
Hi,

I am facing some understanding problem with SOAP basic.kindly recommend some SOAP expert.

Hit counter updating once per IP - IP HIT COUNTER
I have a hit counter, for the amount of views on a tutorial.
It'll do the query and then do..

Sign up to write
Sign up now if you have flare of writing..
Login   |   Register
Follow Us
Indyaspeak @ Facebook Indyaspeak @ Twitter Indyaspeak @ Pinterest RSS



Play Free Quiz and Win Cash