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) . " <a href='haberdetay.php?id=$list[id]'><u>haberin devamı</u> >></a>";
echo $icerik;
}
else
{
echo "$list[ozet]<br /> <a href='haberdetay.php?id=$list[id]'><u>haberin devamı</u> >></a>";
}
?>
<br />
</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 
22 
Other forums
whats wrong with my code please help!!!
this is the error
Warning: mysql_close(): supplied argument is not a valid MySQL-Link res
Code doesn't print what i wanted it too. Please help!
Hi there,
I wrote this code to mae it so that in the form before it that the user said their
Echoing a Variable from a Object
How do I get a variable from the new User Class to echo out in this clasS?
class MyApp
{first id from db not showing
I have a php script which displays the content of a mysql table as a html table with sorting, delete
I got my hosting suspended XD
So I saw this challenge a day or so ago
http://www.programming-challenges.com/pg.php?page=dow
getting rid of quotes in strings
sick of trying to deal with them in multiple ways (entering in and taking from database, echoing, ec
AUTONUMBER PROBLEM
Hello Everyone,
My name is Jones and i am new to this forum and to oracle. I am using ora
insert Multiple rows into the table from that table data
Hi All,
I have a requirement like to insert mulitple rows into the table from that
Save username into DB
OkaY so I got my blog to actually save the posts and whatever, all I need now is for it to keep the
Form File Upload
I've read through tons of resources and tutorials and as far as I can tell, my code is accurate, but
