PHP Code:
<?php
require("./admin/config.php");
$i=1;
$db=mysql_connect($servername,$dbusername,$dbpassword)
or die("Connection à la base de données impossible");
mysql_select_db($dbname)
or die("Impossible de sélectionner la base de données");
$limit=intval($limit);
if (!isset($limit) or $limit<=0 or $limit>50) $limit=15;
$request=mysql_query("SELECT threadid,postid,title,dateline
FROM post
WHERE news='1' AND newstype='News'
ORDER BY dateline DESC LIMIT $limit");
while($result = mysql_fetch_array($request)) {
$news_threadid=$result[threadid];
$news_postid=$result[postid];
$news_title=$result[title];
$news_date=date("d/m",$result[dateline]);
if($i<=8) {
echo "document.write(\"<font face='arial' size='2'><b>$news_date : </b><a href='http://www.newdimension-fr.net/#$news_postid' target='_blank'>$news_title</a></font><br />\");";
} else if($i>8) {
echo "document.write(\"<font face='arial' size='2'><b>$news_date : </b><a href='http://www.newdimension-fr.net/showthread.php?s=&threadid=$news_threadid' target='_blank'>$news_title</a></font><br />\");";
}
$i++;
}
@mysql_free_result($request);
@mysql_close();
?>