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

PHP doesn't send my mail
Hi all, I found this and used it to send mail. Simple contact form with some required fields. The va

Restricted access to sub-folder in iis6 doesn't work?
Basically I'm trying to add restriction to sub-folder (which contains pdf) in web.config for iis6 as

Add trigger to UpdatePanel programmatically
Hi,I'm working on a website which uses AJAX and Masterpages. What I have is an AJAX UpdatePanel whi

Ajax Error since Upgrading to 3.5
Ever since upgrading my site to .NET 3.5 (I needed LINQ), I've been getting this annoying error on o

Allowing ' and "
Hello everyone,

I am creating a form where users submit information to go into a database. I

Open browser page depending on XML results
Hello,

I have some PHP code that sends webbased from data to an external url ( in the form of

Multiple includes losing variables
Hey all,

just starting out w php and ran into a problem pretty quickly. I'm
including seve

login and redirect
hello! can someone help me.. can you give me an idea.. I want to make a login page and redirects it

generate seo frienly url from a text like wordpress
Convert: "åäö" to "aao", "space" to "-", "!?&q

Sales orders ans reservations not taken into account on MPS / MRP
Hello,

I am implementing the MPS / MRP and I have the following problem:

I ha

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