<? include("start.php");
$_SESSION['location']="index.php";
?>
<ul>
<li><a href="empty.php"><span> کنترل پنل اعضا</span></a></li>
<li><a href="comments.php"><span>ارسال خبر جديد</span></a></li>
<li><a href="page.php"><span>آپلود عکس</span></a></li>
<li><a href="archives.php"><span>آرشيو خبرها</span></a></li>
<li class="current_page_item"><a href="index.php"><span>صفحه اصلی</span></a></li>
</ul>
<div class="clearer"> </div>
</div>
</div>
<div class="spacer h5"></div>
<div id="main">
<div class="left" id="main_left">
<div id="main_left_content">
<div class="post">
<div class="post_title">
<h1 class="left"><?
include("sortdb.php");
if(isset($resault))
mysql_free_result($resault);
$k=mysql_connect('localhost','root','');
mysql_select_db("news");
$query="select *from news ORDER BY `number` ASC ";
$r=mysql_query($query);
$num=mysql_num_rows($r);
$query="select *from news ORDER BY `number` ASC limit ".($num-1).",".$num; //last news
$r=mysql_query($query);
$row=mysql_fetch_row($r);
?></h1>
<div class="post_date right">جدیدترین خبر :</div>
<div class="clearer"> </div>
</div>
<div class="post_body">
<h2><? echo $row[0];?></h2><br>
<blockquote><font face="tahoma"><p><b>خلاصه خبر: </b><P><? echo $row[1];?></p></p></font></blockquote>
<? echo $aaa?>
<p><div class="left"><img src=<?
echo $row[4];
?>></div><? echo $row[2];?></p>
<div class="post_metadata">
<div class="content">
<div class="left">
ارسال شده توسط <? echo $row[3];?>
</div>
<div class="right">
<span>تاريخ ارسال : <? echo $row[5]?><?if($row[8])echo " ، ".$row[8];?>
</span>
</div><br>
<div align="center">
<? if($_SESSION["username"]==$row[3] || $_SESSION["Admin"]==true){
echo "<a href='edit.php?num=".$row[7]."'><img src='img/edit.gif'></a>";
echo "<a href='remove.php?num=".$row[7]."'><img src='img/remove.gif'></a>";
}
?>
</div>
<div class="clearer"> </div>
</div>
</div>
</div>
<div class="post_bottom"></div>
</div>
<div class="post">
<div class="post_title">
<div class="post_date right">تازه ها:</div><?
$query="select *from news limit ".($num-2).",".($num-1); //latest
$r=mysql_query($query);
$row=mysql_fetch_row($r);
?>
<div class="clearer"> </div>
</div>
<div class="post_body">
<p><b><?echo $row[0];?></b></p>
<a href='shownews.php?num=<?echo $row[7]?>'>
<p><div class="left"><img src=<?
echo $row[4];
?>></div><? echo $row[1];?></p></a>
<?
$query="select *from news limit ".($num-3).",".($num-2); //latest
$r=mysql_query($query);
$row=mysql_fetch_row($r);
?>
<div class="clearer"> </div>
</div>
<div class="post_body">
<p><b><?echo $row[0];?></b></p>
<a href='shownews.php?num=<?echo $row[7]?>'>
<p><div class="left"><img src=<?
echo $row[4];
?>></div><? echo $row[1];?></p></a>
<?
$query="select *from bestpic";
$r=mysql_query($query);
$num=mysql_num_rows($r);
$query="select *from bestpic where number='$num'"; //latest
$r=mysql_query($query);
$row=mysql_fetch_row($r);
?>
<div class="clearer"> </div>
</div>
<div class="post_body">
<div class="left"><img src=<?
echo $row[0];
?>></div>
<p><b>عکس برگزيده سايت :</b></p>
<a href='<?echo$row[1];?>'>
<p><? echo $row[2];?></p></a>
</div>
</div>
<div class="pagenavigation">
<div class="pagenav">
<div class="right"></div>
</div>
<div class="pagenav_bottom"></div>
</div>
</div>
</div>
<? include("right.php"); ?>
</body>
</html>
