|
include ("banner.php"); ?>
Latest News
include ("menu.php"); ?>
include("connect.php"); $query="select * from federation_news order by id desc limit 8"; $result=mysql_query($query) or die("Cannot find any news details"); while ($newslist=mysql_fetch_array($result,MYSQL_ASSOC)) { $newsid=$newslist['id']; $newstitle=$newslist['title']; $newstext=$newslist['text']; $newstext=substr($newstext,0,60); $newsdate=$newslist['date']; $newsdate=explode("-",$newsdate); $revdate=$newsdate[2]."-".$newsdate[1]."-".$newsdate[0]; echo ""; echo "$revdate : $newstitle"; echo " "; echo $newstext; echo "..... "; echo " "; }; // end while news items (max 8) mysql_free_result($result); mysql_close($link); ?> |